DB2 for z/OS: Database Administration Training

Course #:WA2273

DB2 for z/OS: Database Administration Training

This course provides a detailed understanding of the DB2 for z/OS facilities and procedures required to provide database users with efficient administration and support. It explains the system architecture and facilities of DB2 including monitoring, security and recovery techniques.

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 of DB2 for z/OS: Database Administration Training

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