DB2 UDB for z/OS and OS/390 Data Sharing Recovery/Restart
 

This 2.5 day course is intended for:

System Administrators, Data Base Administrators and Lead Application designers who will be participating in the recovery/restart.

The course will help you understand how recovery works in a data sharing environment and develop the procedures you should have in place to recover from errors or unexpected conditions.

Topics Covered:

• DB2 Data Sharing Recovery Overview
• Database Recovery Environment
• DB2 Restart
• Data Sharing Sysplex Failures
• Data Sharing non-Sysplex Failures
• Disaster Backup and Recovery

Objectives:

At the end of this course, the student should be able to
understand data sharing recovery procedures for:

• Sysplex component recovery
• Database recovery
• Subsystem recovery
• Coupling facility recovery
• Disaster recovery

Duration: 2.5 days   (With limited workshops, Non-disaster Recovery workshops)

Delivery: Class lecture with limited labs

Audience: 

Systems and DB2 professionals (Systems programmers, DBAs as well as support personnel involved in DB2 Data Sharing Recovery.)

Prerequisites:

Working knowledge of DB2 for z/OS or OS/390 systems and database administration.

NOTE:

3 day workshops are available upon request. Call 866.CBI.4YOU (866.224.4968) or write for more information.

Outline

Day 1.

1. DB2 Data Sharing Overview

What is Data Sharing
What's new in terms of Recovery

2. Database Recovery Environment

Logging Environment
Catalog and Directory
Utilities
Logical Page List
LPL and GRECP Recovery
Tablespace Recovery
Establishing Quiesce points

 . DB2 Restart

Retained Locks
Normal Restart
Group Restart
SCA Recovery
Lock Structure Recovery
Conditional Restart

Day 2.

4. Data Sharing Sysplex Failures

Sysplex configuration overview
CPC Failures
Structure Failures
CF Out of Space conditions
Reallocating Group Buffer Pools
Sysplex Timer Failures

5. Data Sharing non-Sysplex Failures

Member Failures
Catalog and Directory Failures
DASD Failures
Application Failures
Short on Storage
SCA
Lock Structures
Group Buffer Pools

Day 3.

6. Disaster Backup and Recovery

Identify the type of Recovery required
Disaster Backup Procedures
Preparing for Disaster Recovery
Coupling Facility Requirements
Dump and Restore Procedures
Backup and Recover to Quiesce Point