Db2 for z/OS Database Recovery and Advanced Utilities

SEE SCHEDULE

Duration: 3 Days

Method: Instructor led, Hands-on workshops

Price: $1920.00

Course Code: DB3011

View Related Video

Audience

Db2 Database and System Administrators who will be managing and recovering Db2 Databases.

Description

Personnel who will be participating in the Recovery of Db2 for z/OS Databases and Applications require a comprehensive understanding of the recovery environment and procedures. Our hands-on workshops detail Unit of Work Recovery, Current and prior point in time recovery, failure analysis, recovering from media failures, as well as building and implementing Db2 Recovery related procedures. During our training exercises we will build and execute online and stand-alone utilities to support the recovery scenarios for their private databases. Both data sharing and non-data sharing recovery considerations are covered.

Objectives

Upon successful completion of this course, the student will be able to:

Describe the Db2 Recovery Environment
Develop and implement Backup and Recovery procedures
Analyze failures and identify what type of recovery procedure is appropriate
Perform media recovery of their database objects
Perform prior-point-in-time recovery
Demonstrate a working knowledge of the Db2 stand-alone utilities

Prerequisites

DB3010 Db2 for z/OS Database Administration or equivalent experience. A basic understanding of Db2 for z/OS utilities is assumed.

Topics

I. Db2 Recovery Environment Overview
- Db2 Recovery Related System Objects
  - Bootstrap Dataset (BSDS)
  - Db2 Logs
  - Units of Recovery
  - Log Records
  - Db2 Catalog Objects
  - Db2 Directory
- Types of Recovery
- Backup & Recovery Procedures
II. Db2 Recovery Related Commands
- Database Commands
  - Starting Databases
  - Monitoring Databases
  - Restricted Statuses
  - Database Use
  - Database Locks
  - CLAIMERS
  - Pages in Error
  - Stopping Databases
- Thread & Related Commands
  - Display Threads
  - Terminate Threads
  - Reset Indoubt
  - Recover Indoubt
  - Display DDF
- Logging Environment Commands
  - Display Log
  - Set Log to modify logging environment
- Monitoring using Db2 Commands
III. Preparing for Recovery
- COPY Utility
  - Data Checking
  - Copy Pending Status
  - Conditional Image Copies
  - Using FlashCopy
  - Copy Phases
  - Restart Considerations
  - Copy Parallelism
- QUIESCE Utility
- LISTDEF & TEMPLATE
- Merging Image Copies
- COPYTOCOPY Utility
- OPTIONS PREVIEW
- MODIFY RECOVERY Utility
- Recommendations
IV. Database Recovery
- Backup and Recovery Procedures
- What Happens During Recovery
- Complete Recovery Cycles
- Recovery Information
- REPORT Utility
  - Problem Analysis
- Recovery Pending Status
- RECOVER Utility
  - Recovery Phases
  - Recovery Objects
  - Point in Time Recovery
  - Recommendations
- Rebuilding Indexes
- Complete Referential Set Recovery
- Types of Recovery
  - Log-Only Backout
  - ERROR RANGE Recovery
  - LPL Errors
  - Invalid LOBs
  - Down-Level Pageset
  - LOGONLY Recovery
- REPAIR Utility
- MODIFY Utility
- Recommendations
V. Stand-alone Utilities
- Print Log Map Utility
  - DSNJU004 Utility
  - Report output analysis
- Recovery Log Contents
  - DSN1LOGP Utility
  - Control Statements
  - Report output analysis
  - When to use DSN1LOGP
- DSN1COPY
  - Usage
  - Requirements
  - Validation
- Stand-alone Utility Recommendations
VI. Unloading Data
- UNLOAD utility
  - Usage
  - Concurrency
  - Control Statements
  - Output
- DSNTIAUL Sample Application
  - Usage
  - Concurrency
  - Parameters
  - Output
- Recommendations
VII. Recovery Scenarios Unique to a Data Sharing Environment
- Data Sharing Overview
- Logging Environment
- Recovery from CF failures
  - Group Buffer Pools
  - Lock Structure
  - SCA Structure
- Recommendations