DB2 for z/OS: DB2 Utilities for DBAs Training

Course #:WA2225

DB2 for z/OS: DB2 Utilities for DBAs Training

An ability to use and exploit the utilities provided with DB2 for z/OS is essential for today's DBAs. This course provides an in-depth understanding of the utilities provided with DB2 for z/OS, explaining the need for the utility, the major control statements used and operational considerations. All online and stand-alone utilities are discussed and explained.

Objectives

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

  • identify and describe the need for the various DB2 utilities
  • understand the main control statement options for each online utility
  • understand the main parameters for controlling each stand-alone utility
  • identify and describe the operational considerations when using utility jobs.

Audience

This course is intended for DB2 database administrators and other DB2 support personnel.

Prerequisites

Experience of working with DB2 for z/OS in a support or administrator role.

Duration

3 days

Outline of DB2 for z/OS: DB2 Utilities for DBAs Training

1. Utilities for Data Integrity & Consistency

  • The CHECK DATA, CHECK INDEX and CHECK LOB online utilities.

2. Utilities for Data Management

  • The LOAD and UNLOAD online utilities.

3. Utilities for Data Backup and Recovery

  • The COPY, COPYTOCOPY, MERGECOPY, RECOVER, REBUILD, QUIESCE and REPORT online utilities.

4. Utilities for Maintenance and Housekeeping

  • The REORG TABLESPACE, REORG INDEX, RUNSTATS, MODIFY, STOSPACE and REPAIR online utilities.

5. Utilities for System-wide Backup and Recovery

  • The BACKUP SYSTEM and RESTORE SYSTEM online utilities.

6. Stand-alone Utilities

  • The DSN1COPY, DSN1PRNT, DSN1LOGP, DSN1COMP, DSN1CHKR, DSNJU004, DSNJU003 and DSNJLOGF stand-alone utilities.

7. Operational Considerations

  • Concurrency between utilities; availability; CLAIMS and DRAINS; utility restrictive states.

 

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.