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.

Audience

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

Prerequisites

Attendees should be familiar with the DB2 environment and have knowledge of SQL or have attended the RSM courses DB2 for z/OS: Introduction, Concepts & Facilities and DB2 for z/OS: SQL for Query Users.

Duration

3 days

Outline for DB2 for z/OS: Database Administration

1. DB2 Environment Overview

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

2. DB2 Pagesets

  • Pageset structure
  • Tablespace types and defaults
  • Index structure
  • Data compression.

2. DB2 Security & Data Control Language

  • The grant and revoke statements
  • Explicit and implicit privileges
  • Object privileges
  • Administrative privileges
  • Install SYSADM/SYSOPR
  • Using RACF profiles
  • Multilevel security
  • row & column level security.

3. Utilities Overview

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

4. Online Data Utilities

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

5. Online Recovery Utilities

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

6. Stand-alone Utilities

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

7. Catalog & Directory Recovery

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

8. Performance Monitoring

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

9. Practical Exercises

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