On successful completion of this course you 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.

• 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
• 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
• Introduction to Db2 Utilities
  • Db2 utilities
  • Db2 utility packaging
  • Invoking online utilities - Db2i defaults panel
  • Invoking online utilities - Db2 utilities panel
  • Invoking online utilities - dataset names panel
  • Invoking online utilities - control statements panel
  • Control statements
  • LISTDEF control statement
  • Use of Wild Cards with LISTDEF
  • TEMPLATE control
• Utilities for Data Integrity
  • CHECK DATA utility
  • CHECK INDEX utility
  • CHECK LOB utility
  • REPAIR utility
• 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
• 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
• 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
• 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

Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion. 
This course is also available for exclusive, one-company presentations and for live presentation over the Internet, via the Virtual Classroom Environment service.

Delivered as a live, interactive online training.

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.

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.