Db2 for z/OS: Data Recovery Eğitimi

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.

• 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.