The course provides detailed coverage of DB2 for z/OS V8 and V9 System and Disaster Recovery. It is intended for DBAs and Systems Programmers. A good general knowledge of DB2 is a prerequisite.
3 days theory-only, or 4 days with workshops
1 Recovery Overview - Backup & Recovery. - The Unit of Recovery. - Logging. - DB2 Buffer Pools. - Commit Processing. - Forward Recovery and Rollback. - Locking. 2 DB2 Utilities 3 Standard Backup and Recovery - Image Copy. - Recovery and Index Recovery. - Mergecopy, Report Recovery, and Modify. - Concurrent Copy. - Inline Image Copies. - LISTDEF and TEMPLATE. 4 Recovery Data - Image Copies. - Logs & BSDS. - Log Records. - Catalog & Directory. 5 Physical Database Organisation 6 Data Object States - Possible Statuses. - Resetting States. - Check Data, Check LOB, Check Index. - Repair. - Error Range and LPL. 7 Recovery to a Prior Point in Time - Point of Consistency. - Quiesce. - Report Tablespaceset. - Recovery to a POC. - Recover Tocopy and Recover Logonly. - DSN1COPY. 8 Recovery after Drop 9 Third Party Utilities 10 Catalog & Directory Recovery - Catalog & Directory Backup and Recovery. - Point in Time Recovery. - Work Database Recovery. - DSN1CHKR. 11 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. 12 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. 13 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.