Db2 13 for z/OS Recovery

Nov 4, 2025 to Nov 6, 2025
Location: Virtual
Categories: Courses, Db2, Hands on Labs
Latest Activity: Sep 2

Register Now

Db2 13 for z/OS Recovery – Protect Your Data, Protect Your Business

Downtime is costly. Data loss is critical. This intensive course empowers IT professionals with the knowledge and practical skills needed to recover Db2 for z/OS systems quickly and effectively—ensuring business continuity when it matters most.

Through a blend of expert instruction and real-world labs, you’ll:

Master Db2 backup and recovery utilities.
Restore data objects to a prior point in time with confidence.
Tackle dropped object recovery and catalog/directory repair.
Navigate subsystem shutdowns, restarts, and log/BSDS failures.
Build robust disaster recovery strategies, including IBM GDPS solutions.

Whether you’re an experienced DBA or new to recovery planning, this course will strengthen your expertise and give you the confidence to safeguard critical enterprise data.

Course Objectives

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. The class is relevant to Db2 13 and any recent previous versions of the product.

Course Content

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. 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
Backups
System Wide POC
Volume Dump POC
Flash Copy
Using Log Suspend
BACKUP SYSTEM
DB2 POC
Copying Archive Logs
Recovery to Last Log
RESTORE SYSTEM
Utilities In Flight
DB2 Synchronisation with CICS and IMS
Fallback Options
Tracker Site
IBM GDPS Concepts and Solutions Overview

Events