DB2 9 for z/OS Advanced System and Disaster Recovery Workshop
- Vendor:
- IBM Corporation
- Course:
- CV910
- Start Date:
- Tuesday, February 21, 2012
- Length:
- 4 Days
- Location:
- Expired Class Date
- Tuition:
- $2,680
- Expired:
- This class has expired. Current Class
February
21
Expired Class Date
Course Description
The course is designed to provide instruction in the design and implementation of recovery and restart procedures for DB2 which maximize availability.
Skills Gained
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
Who Can Benefit
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.
Prerequisites
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.
