Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley

locations map


550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2


821A Bloor Street West
Toronto, ON
M6G 1M1


409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA

Other Locations

Dallas, TX
Miami, FL

Home > Training > DB2 > DB2 for z/OS: Data Recovery Training

DB2 for z/OS: Data Recovery Training

Course#: WA2161

Covering DB2 for z/OS environments, this course provides attendees with a comprehensive introduction to the recovery of DB2 objects. The course examines all the provided DB2 utilities and service aids, and discusses their involvement in recovery scenarios involving user data and DB2 data such as the catalog and directory.


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.


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.


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.


2 days

Outline of WA2161 DB2 for z/OS: Data Recovery Training

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
  • 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
  • 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
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:


*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.


Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.