> > CV891G

DB2 for z/OS Application Data Recovery (CV891G)

Course Description Schedule

Who should attend

This intermediate course is for individuals who support and implement application data backup and recovery procedures for DB2 9 or DB2 10 for z/OS.


  • DB2 9 for z/OS Database Administration Workshop - Part 1 (CV830) or
  • DB2 9 for z/OS Database Administration Workshop - Part 1 - Instructor Led Online (3V830) or
  • Possess equivalent knowledge.

Course Objectives

Design and implement application data backup and recovery procedures for their installations.

Course Content

  • Backup and recovery basics
    • Describe the major situations requiring the recovery of data
    • Explain the basic DB2 logging concept
    • Explain the basic DB2 backup and recovery concept
    • Describe the restrictive and advisory states relevant for backup and recovery
    • Explain the purpose of the Logical Page List and of Write Error Page Ranges
  • Normal backup of table and index spaces (normal backup in this context means the creation of DB2 image copies using the COPY utility)
    • Create full and incremental image copies or inline copies for table spaces
    • Create conditional image copies for table spaces
    • Create image copies for indexes
    • Establish additional copies of image copies
    • Merge full and incremental image copies to obtain new full or incremental image copies
    • Delete image copies no longer needed
  • Normal recovery of table and index spaces (normal recovery in this context means the recovery using DB2 image copies and the RECOVER utility)
    • Prepare the recovery of a table space or index space
    • Recover a table space or COPY enabled index space to current
      • An entire table space or index space
      • A partition or data set
      • An error range
    • Replace defective volumes during recovery
    • Relate the fallback recovery concept
    • Rebuild indexes
  • Point-in-time recovery (normal recovery to an earlier point in time for table spaces and index spaces)
    • Plan for point-in-time recoveries
    • Prepare point-in-time recoveries
    • Perform point-in-time recoveries involving table spaces other than LOB table spaces
  • Generic utility jobs (LISTDEF, TEMPLATE, and OPTIONS as far as they are relevant for backup and recovery)
    • Provide reusable list definitions for use by the DB2 utilities
    • Use list definitions in utility control statements and understand how they expand
    • Describe the concept and working of templates replacing utility Dataset Definition (DD) statements
    • Use templates in utility jobs to simplify Job Control Language (JCL)
    • Use templates together with list definitions
    • Use the OPTIONS utility control statement to control execution parameters for utility jobs
  • Using nonstandard copies (for the backup and recovery of table spaces or index spaces)
    • Establish DB2 Data Facility Storage Management Subsystem (DFSMS) concurrent copies using the CONCURRENT option of the COPY utility
    • Restore DB2 DFSMS concurrent copies established using the CONCURRENT option
    • Understand the prerequisites for establishing nonstandard copies
    • Establish and restore nonstandard copies using the DSN1COPY stand-alone utility
    • Establish and restore nonstandard copies using native DFSMS Data Set Services (DFSMSdss)
    • Apply log changes to restored copies
  • Special recovery situations (including down-level data, the recovery of dropped objects, and the repair of pages)
    • Handle down-level data
    • Prevent the accidental dropping of tables, table spaces, or databases
    • Recover accidentally dropped table spaces
    • Recover accidentally dropped tables
    • Print and analyze pages of table spaces or partitions
    • Repair pages of table spaces if necessary
  • Application recovery (how application programs should be structured to preclude recovery problems and what can be done if they do not follow these recommendations)
    • Convince application programmers to structure programs into committable units
    • Teach application programmers how to make programs restartable
    • Instruct system programmers how to postpone backout work during DB2 restarts
    • Cancel the postponed backout for objects being recovered or replaced
Classroom Training

Duration 3 days

Price (excl. tax)
  • Germany: 2,290.- €
  • Switzerland: Fr. 2,860.-
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Bread
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.

Digital courseware Dates and Booking
Click on town name to bookSchedule
30/01/2017 - 01/02/2017 Frankfurt
27/03/2017 - 29/03/2017 Stuttgart
22/05/2017 - 24/05/2017 Hamburg
17/07/2017 - 19/07/2017 Munich
04/10/2017 - 06/10/2017 Düsseldorf
06/11/2017 - 08/11/2017 Berlin
27/03/2017 - 29/03/2017 Zurich
17/07/2017 - 19/07/2017 Vienna (iTLS)