DB2 11 for z/OS Recovery

The course provides detailed coverage of DB2 for z/OS application data recovery, subsystem recovery and restart, and disaster recovery.  The course includes detailed hands on practical exercises.

This course is intended for systems programmers, DBAs, and anyone else who needs to understand DB2 11 recovery in detail.

A good general knowledge of DB2 is a prerequisite.

This course will teach DB2 for z/OS application data recovery, subsystem recovery and restart, and disaster recovery.

1. DB2 Objects

2. Physical Database Organisation

3. Recovery Overview

4. DB2 Utilities

5. Standard Backup and Recovery
Image Copy
Recovery and Index Recovery
Mergecopy and Report Recovery
Modify
Concurrent Copy and Inline Image Copies
LISTDEF and TEMPLATE

6. Recovery Data
Image Copies
Logs & BSDS
Log Records
Catalog & Directory

7. Data Object States
Display Database Command
Possible Statuses
Resetting States
Check Data, Check LOB, Check Index
Repair
Error Range and LPL

8. Recovery to a Prior Point in Time
Point of Consistency
Quiesce
Report Tablespaceset
Recovery to a POC
Recover Tocopy
DSN1COPY
Recover Logonly

9. Recovery after Drop
Problems Caused by Drop
Recovering the Data
Finding the Object IDs
DSN1PRNT

10. Third Party Utilities

11. Catalog & Directory Recovery
Catalog & Directory Backup and Recovery
Point in Time Recovery
Work Database Recovery
DSN1CHKR

12. Subsystem Shutdown & Restart
Normal Shutdown
Fast Controlled Shutdown
Uncontrolled Shutdown
Restart Processing
Log Initialization
Current Status Rebuild
Two Phase Commit
Forward and Backward Log Recovery
Postponed Abort and Deferred Restart
Resolving In-Doubt URs

13. Log and BSDS Failures
Active and Archive Log Errors
BSDS Failures
Print Log Map Utility
Change Log Inventory Utility
DSN1LOGP
Log Failures on Restart
Conditional Restart

14. Disaster Recovery
Objectives
System Wide POC
Volume Dump POC
Using Log Suspend
BACKUP SYSTEM
DB2 POC
Recovery to Last Log
Utilities In Flight
DB2 Synchronisation with CICS and IMS
Fallback Options
Tracker Site
DASD Mirroring
XRC Global Mirror for z/OS