On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

DB3011 DB2 for z/OS Database Recovery and Advanced Utilities
Duration3 Days
Delivery MethodInstructor Led, Hands-on workshops
Public Price$1920.00

DESCRIPTION (Return to Top)

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.

AUDIENCE (Return to Top)

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

OBJECTIVES (Return to Top)

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
  • Display a working knowledge of the DB2 stand-alone utilities

TOPICS (Return to Top)

  • DB2 Recovery Environment Overview
  • DB2 Recovery Related Commands
  • Preparing for Recovery
  • Database Recovery
  • Stand-alone Utilities
  • Unloading Data
  • Recovery Scenarios Unique to a Data Sharing Environment


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