DB2 for z/OS Application Data Recovery

The course provides detailed coverage of DB2 for z/OS Application Data Recovery.

This course 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. Students should have attended the DB2 for z/OS Administration course, or have equivalent knowledge/experience.

The course provides detailed coverage of DB2 for z/OS Application Data Recovery (see below for content).

The course includes practical exercises.

DB2 Objects
Tables.
Storage Groups & Databases.
Tablespaces.
Indexes.
Free Space and Compression.
Large Objects.
The Catalog and Directory.

Physical Database Organisation
Tablespace Layout and Index Structure.

Recovery Overview
Backup & Recovery.
The Unit of Recovery.
Logging.
DB2 Buffer Pools.
Commit Processing.
Forward Recovery and Rollback.
Locking.

DB2 Utilities
Standard Recovery Utilities.
Utilities that Impact Recovery.
Stand Alone Utilities.
Invoking Utilities.

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

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

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

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

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

Third Party Utilities
Using third party utilities.
General differences.
BMC Copy Plus and Recover Plus.