The course provides detailed coverage of DB2 for z/OS Version 7 and Version 8 Application Data Recovery. It is intended for application DBAs and designers and anyone else who needs to understand DB2 data recovery. A good general knowledge of DB2 is a prerequisite. The course includes practical exercises.
3 days
1 DB2 Objects - Tables. - Storage Groups & Databases. - Tablespaces. - Indexes. - Free Space and Compression. - Large Objects. - The Catalog and Directory. 2 Physical Database Organisation - Tablespace Layout and Index Structure. 3 Recovery Overview - Backup & Recovery. - The Unit of Recovery. - Logging. - DB2 Buffer Pools. - Commit Processing. - Forward Recovery and Rollback. - Locking. 4 DB2 Utilities - Standard Recovery Utilities. - Utilities that Impact Recovery. - Stand Alone Utilities. - Invoking Utilities. 5 Standard Backup and Recovery - Image Copy. - Recovery. - Index Recovery. - Mergecopy. - Report Recovery. - Modify. - Concurrent Copy. - 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, and 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 - Using third party utilities. - General differences. - BMC Copy Plus and Recover Plus.