Audience
This course is intended for application DBAs and designers and anyone else who needs to understand Db2 data recovery.
Prerequisites
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.
Duration
3 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
The course provides detailed coverage of Db2 for z/OS Application Data Recovery. It is applicable to all recent Db2 for z/OS versions, up to and including Db2 13.
The course includes practical exercises using a dedicated labs sysgtem running the latest version of Db2 13 for z/OS. Previous versions are available on request.
Course Content
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.