DB2 9 for z/OS: Database Administration

Objectives

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

• describe the DB2 environment, and understand the use of key DB2 components such as buffer pools, the DB2 catalog and directory, logging data sets, etc.
• describe the internal structure of DB2 UDB for z/OS databases
• understand and assess security and related requirements
• use DB2 commands to monitor and control DB2 objects, processes and operations
• understand and use the full complement of DB2 online data and recovery utilities
• understand and use the DB2 stand-alone utilities
• use DB2 traces to record performance monitoring information
• understand and interpret information in DB2PM accounting and statistics reports.

Who Should Attend

Those responsible for the ongoing support and administration of DB2 for z/OS databases.

ContentsDB2 Environment Overview

DB2 address spaces; Attachments; Log data sets; Catalog; Directory; Buffer pools; bufferpool thresholds; bufferpool hit ratio; usage considerations.

DB2 Pagesets

Pageset structure; Tablespace types; Index structure; Data compression.

DB2 Security and Data Control Language

The grant and revoke statements; Explicit and implicit privileges; Object privileges; Administrative privileges; Install SYSADM/SYSOPR.

Utilities Overview

Online utilities; stand-alone utilities; control statements; DB2I Utilities option; using LISTDEF; using TEMPLATE; OPTIONS statement.

Online Data Utilities

RUNSTATS; LOAD; UNLOAD; CHECK DATA; CHECK INDEX; CHECK LOB; REORG; STOSPACE; REPAIR.

Online Recovery Utilities

Recovery components; COPY; COPYTOCOPY; MERGECOPY; REPORT; QUIESCE; RECOVER; REBUILD; MODIFY; BACKUP SYSTEM; RESTORE SYSTEM.

Stand-alone Utilities

DSN1COPY; DSN1PRNT, DSN1LOGP; DSN1COMP; DSN1CHKR; DSNJU004; DSNJU003; DSNJLOGF.

Catalog & Directory Recovery

Catalog / Directory recovery; Recovery sequence; Point-in-time recovery implications.

Performance Monitoring

DB2 traces; Controlling traces; DB2PM Accounting reports; DB2PM Statistics reports.

Practical Exercises

Using data utilities; using backup & recovery utilities; using stand-alone utilities.