Objectives

On successful completion of this course attendees will be able to:

  • describe the structure and format of DB2 pagesets
  • list all of the major recovery components
  • describe the need for DB2 logging to assist in recovery situations
  • describe the need for and use of all DB2 utilities
  • identify when service aids may be required for use in recovery situations
  • describe the additional considerations when recovering catalog and directory tablespaces.

Audience

This course is designed for all those involved in the day to day support of a DB2 for z/OS sub-system, as well as those responsible for recovery of DB2 objects and data.

Prerequisites

While in-depth knowledge of DB2 is not required, a basic understanding of relational databases is assumed. Familiarity with TSO/ISPF and JCL is also required.

Duration

2 days

Outline for DB2 for z/OS: Data Recovery

1. DB2 Physical Data Storage

  • VSAM file requirements
  • Creating VSAM files
  • Page sets
  • Page set structure
  • Index structure
  • Index keys & pointers
  • Data navigation
  • RIDS, pointers, and holes
  • Table row header format
  • Large Object data
  • Large Object columns
  • XML data
  • XML storage structure names

2. DB2 Logging

  • DB2 logging
  • Unit Of Recovery
  • Two phase commit
  • Logging parameters - size & number of logs
  • logging parameters - checkpoints
  • Checkpoint records
  • Forcing an archive log

3. Introduction to DB2 Utilities

  • DB2 utilities
  • DB2 utility packaging
  • Invoking online utilities - DB2I defaults panel
  • Invoking online utilities - DB2 utilities panel
  • Invoking online utilities - data set names panel
  • Invoking online utilities - control statements panel
  • Control statements
  • LISTDEF control statement
  • Use of Wild Cards with LISTDEF
  • TEMPLATE control

4. Utilities for Data Integrity

  • CHECK DATA utility
  • CHECK INDEX utility
  • CHECK LOB utility
  • REPAIR utility

5. Utilities for Backup & Recovery

  • Backup & recovery components
  • COPY utility
  • COPY list of objects
  • COPY using LISTDEF and TEMPLATE
  • COPYTOCOPY utility
  • MERGECOPY utility
  • QUIESCE utility
  • RECOVER utility
  • RECOVER list of objects
  • Recovery involving referential integrity
  • Recovery and large objects: recover either to current point, recover either to prior point, recover both to prior point
  • Resetting status codes
  • XML data recovery
  • REBUILD INDEX utility
  • REPORT utility
  • MODIFY utility
  • BACKUP SYSTEM utility
  • RESTORE SYSTEM utility
  • Restoring to a specified point

6. Other Online Utilities

  • LOAD utility
  • REORG TABLESPACE utility
  • Using shadow copies during REORG
  • REORG utility - BUILD2 phase
  • Shadow copies - FASTSWITCH
  • RUNSTATS utility
  • STOSPACE utility
  • UNLOAD utility

7. Stand-Alone Utilities (service aids)

  • Invoking stand-alone utilities
  • DSN1COPY stand-alone utility
  • DSN1PRNT stand-alone utility
  • DSNJU004 (print log map) stand-alone utility
  • DSNJU003 (change log inventory) stand-alone utility
  • DSN1LOGP stand-alone utility
  • DSN1CHKR stand-alone utility
  • DSN1COMP stand-alone utility
  • DSNJLOGF stand-alone utility
  • DSNJCNVB stand-alone utility

8. Catalog & Directory Recovery

  • Catalog / Directory recovery implications
  • Recovery sequence
  • Catalog & Directory point-in-time recovery
  • Recovery implications - DEFINE option
  • Recovery implications - FASTSWITCH
  • Recovery implications - identity columns & sequences
  • System-wide points of consistency