DB2 for z/OS Data Sharing Recovery and Restart

The course looks in detail at the new modes of failure introduced by DB2 Data Sharing. Each mode of failure and the appropriate recovery procedure is discussed.

This is an advanced course suitable for DBAs, systems programmers, operations personnel, and anyone involved DB2 Data Sharing recovery.

Students should have some knowledge of DB2 for z/OS system and disaster recovery.

The course looks in detail at the new modes of failure introduced by DB2 Data Sharing. Each mode of failure and the appropriate recovery procedure is discussed. The course can be taught as theory-only. Alternatively, the lecturer can demonstrate recovery from selected modes of failure during the course.

Overview
Parallel Sysplex.
DB2 Data Sharing.
Protecting Data Consistency.
Group Buffer Pools.
Global Locking.

Recovery Issues
Application Data Recovery.
CF Structure Failures.
CFRM Policy.
GBP Duplexing.
DB2 Member Failure.
Disaster Recovery.
CF v ICF.

Operation & Monitoring
Console Messages.
DB2 Commands.
MVS XCF Commands.
Retained Locks.
DB2 Traces.

Application Data Recovery
Log RBA and LRSN.
Recover Utility.

CF Link Failures
Single CF Link Failure.
One MVS Loses Links to SCA.
One MVS Loses Links to LOCK1.

CF Failures
Loss of CF Containing SCA.
Loss of CF Containing LOCK1.
SCA and LOCK1 Duplexing.

GBP Failures without GBP Duplexing
One MVS Loses Links to GBPs.
Loss of CF Containing GBPs.

GBP Failures with GBP Duplexing
One MVS Loses Links to GBPs.
Loss of CF Containing GBPs.

DB2 Subsystem Failure
DB2 Subsystem Failure.
MVS Image Failure.
Restart Light.

Multiple Failures
Normal Restart.
Loss of All CFs.
Group Restart.

Disaster Recovery
Objectives.
Backups.
System Wide POC.
Volume Dumps.
Using Log Suspend.
BACKUP SYSTEM.
Copying Archive Logs.
Recovery to Last Log.
Utilities In Flight.
CICS and IMS Synchronisation.
Fallback Options.
Tracker Site.