Home About Courses Schedule Services Webinars Contact Search

Db2 for z/OS Database Recovery and Advanced Utilities


Duration: 3 Days

Method: Instructor led, Hands-on workshops

Price: $1920.00

Course Code: DB3011

View Related Video


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


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.


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


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


  • 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
    • Merging Image Copies
    • COPYTOCOPY 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