ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

DB2 9 for z/OS Advanced System and Disaster Recovery Workshop  (CV910)

Format: Formation en classe avec formateur
Autres formats:
 
 

The course is designed to provide instruction in the design and implementation of recovery and restart procedures for DB2 which maximize availability.

 
This Course is Certified By IBM   Flex Training Savings
 

Compétences acquises

 
  • Implement and describe disaster recovery concepts based on archive logs and image copies
  • Judge on the variety of available Conditional Restart options
  • Describe a DB2 cold start and identify the few situations in which it is a suitable solution in case of restart failures
  • Pick the correct ZPARM settings depending on which restart behavior is desirable for each DB2 subsystem
  • Implement and make use of BACKUP and RESTORE system utilities
  • Explain why levelid checking is a very important means for DB2 to maintain data consistency
  • Develop procedures for diagnosing and recovering broken data, including catalog and directory data
  • Deal with LPL restricted page sets
  • Take the right steps to Copy and Recover the DB2 catalog and directory

Qui peut en profiter

 

This is an advanced course for responsible for DB2 system or database recovery.

While the course labs are performed on a DB2 9 for z/OS system, the content is appropriate for individuals in a DB2 10 for z/OS environment.

Préalables

 

You should have:

  • attended the course DB2 9 for z/OS Database Administration Part 1 (CV830XBE), DB2 9 for z/OS System Administration (CV85) and DB2 9 for z/OS Application Recovery (CV89) or must have attained a similar level of experience.

Abstract

 

IBM Education Advantage Program Eligibility:

  • Yes - IBM Education Pack - online account
 
Enroll For This Class
Enroll For This Class
 DB2 Lotus Tivoli Training Class Ce cours est donné par des formateurs certifiés IBM.

À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.

Il y a une différence. Découvrez-la
Training Class Enrollment Ask A Question About This Training
Code: CV910
Format: Formation en classe avec formateur
Durée: 4 days
Certifié par: IBM
Frais d’inscription (CAD): $contact
TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
     
Durham/Raleigh, NC Nov.26 - Nov.29.2012 course register
1 Dates Offered      
   
demander une autre date/un autre emplacement demander de la formation sur place
 

DB2 9 for z/OS Advanced System and Disaster Recovery Workshop  (CV910) Contenu détaillé

 
 
Backup and Recovery Review
  • List DB2 data backup and recovery utilities
  • Analyze the contents of SYSIBM.SYSCOPY and SYSIBM.SYSLGRNX
  • Understand recovery alternatives
  • Establish a point of consistency
  • Explain what causes each of the page set exceptions and how to resolve them
Logs and BSDS
  • Describe the DB2 recovery logging process
  • Understand the offloading process
  • Analyze the contents of the: BSDS, Active log data sets, Archive log data sets
  • List functions of DB2 log-related utilities
Introduction to Remote-Site Recovery
  • Identify requirements for remote-site recovery
  • Describe a very basic method for remote-site recovery
Termination/Restart
  • Explain the processing done by DB2 during startup and shutdown
  • Implement procedures to avoid the most common problems associated with DB2 startup and shutdown
Conditional Restart
  • Analyze a DSN1LOGP SUMMARY report
  • Perform a conditional restart
  • Identify potentially inconsistent page sets resulting from a conditional restart
  • Resolve any data inconsistencies resulting from a conditional restart
Broken User Data
  • Describe the format of user page sets
  • List the health check utilities for helping to resolve problems with user page sets
  • Identify problems with user page sets
  • Resolve problems with user page sets
Broken System Data
  • Describe links, hashes, and database descriptors (DBDs)
  • Diagnose broken data problems for system data
  • Implement health check procedures for system data
  • Establish procedures for resolving broken system data problems
 
Down-Level Detection
  • Describe what down-level page sets are
  • Explain how DB2 detects down-level page sets
  • Describe what you can do to recover from down-level data
System POC Recovery
  • Design procedures to establish system-wide POCs
  • Design procedures to recover to system-wide POCs
Offsite Recovery
  • Set the procedure in place for offsite recovery
  • Recover using the procedure established at the offsite location
Agenda
 
Day 1
  • Unit 1: Backup/Recovery
  • Unit 2: Logs and BSDS
  • Unit 3: Introduction to Remote-Site Recovery
  • Exercise Introduction
  • Exercise 1: Establish a DB2 Environment
  • Exercise 2: Enlarging Catalog Page Sets (Optional)
  • Exercise 3: Changing Active Log Size (Optional)
Day 2
  • Unit 4: Termination/Restart
  • Unit 5: Conditional Restart
  • Exercise 4: Using CRCR with BACKOUT=NO
  • Exercise 5: Consistent Restart
  • Exercise 6: Consistent Restart: DDL Backout (Optional)
  • Exercise 7: Resolving LPLs (Optional)
Day 3
  • Unit 6: Broken User Data
  • Unit 7: Broken System Data
  • Exercise 8: Critical Log Read Error
  • Exercise 9: Critical Log Read Error with DDL
  • Unit 8: Down-Level Detection
Day 4
  • Exercise 10: Down-Level Detection
  • Unit 9: System POC Recovery
  • Unit 10: Offsite Recovery (without BACKUP/RESTORE)
  • Exercise 11: Dilemma with a DB2 Cold start
  • Unit 10: Offsite Recovery (Cont.)
  • BACKUP/RESTORE demo


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.
 
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI