DB2 for z/OS Application Data Recovery CV891G

Days: 3 day
Price: $2295

Course Details

Learn how data and index recovery is supported by DB2 for z/OS in order to develop the knowledge and skills you need to design and implement backup and recovery procedures for your installations.

Practice using the utility functions and techniques included in the lecture material during extensive interactive machine lab exercises on a z/OS system.

Course Materials

The course materials cover DB2 for z/OS V9. The content is also appropriate for those who are working on DB2 10 for z/OS.

Hands-On Labs

Six labs are included to address functionality of DB2 for z/OS application recovery.

Course Agenda

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
  • Advise system programmers in canceling threads without backout being performed
  • Instruct system programmers how to postpone backout work during DB2 restarts
  • Cancel the postponed backout for objects being recovered or replaced

Daily Agenda

Day 1

  • Backup and recovery basics
  • Normal backup of table and index spaces
  • Exercises: normal backup of table and index spaces
  • Review exercises: normal backup of table and index spaces
  • Normal recovery of table and index spaces
  • Exercises: normal recovery of table and index spaces
  • Review exercises: normal recovery of table and index spaces

Day 2

  • Point-in-time recovery
  • Exercises: point-in-time recovery
  • Review exercises: point-in-time recovery
  • Generic utility jobs
  • Exercises: generic utility jobs
  • Review exercises: generic utility jobs

Day 3

  • Using nonstandard copies
  • Exercises: using nonstandard copies
  • Review exercises: using nonstandard copies
  • Special recovery situations
  • Exercises: special recovery situations
  • Review exercises: special recovery situations
  • Application recovery