Verhoef Training, Inc.

P.O.Box 1515, West Caldwell, NJ 07006
Phone:(800)631-0410 Fax:(973)403-3468



DB2 System Performance Tuning




SUMMARY:   The course provides detailed coverage of DB2 System Performance Tuning for DB2 UDB for z/OS and OS/390. It is intended for DBAs and systems programmers. A good working knowledge of DB2 is a prerequisite. The course includes demonstrations using any available on-line DB2 performance monitor.

DURATION:   5 Days

COURSE CONTENT:  
  1. Introduction
    • What is Performance?
    • Performance Factors.
    • Performance Objectives.
  2. DB2 Architecture
    • DB2 Address Spaces.
    • RDS, DM and BM.
    • Connections and Threads.
    • Serialisation Mechanisms.
    • Resource Accounting.
  3. System Performance Factors
    • Virtual Storage Layout.
    • DBAS Storage.
    • DB2 System Parameters.
    • Allied Address Spaces.
    • DB2 and Workload Manager.
  4. Buffer Pool Processes
    • Buffer Pool Basics.
    • Virtual Pools and Hiperpools.
    • VBPs in Data Spaces.
    • Getpage Processing.
    • Sequential, Dynamic, and List Prefetch.
    • Parallelism.
    • DB2 Sort.
    • Buffer Pool Thresholds.
  5. Monitoring & Tuning the Buffer Pools
    • Buffer Pool Assignments.
    • Using Hiperpools and Data Spaces.
    • Buffer Pool Settings.
    • Prefetch and Parallelism.
    • Monitoring and Tuning the Buffer Pools.
  6. Measuring & Reporting
    • DB2 Instrumentation Facility.
    • Statistics, Accounting, and Performance Traces.
  7. The EDM Pool
    • EDM Pool Management.
    • Dynamic Statement Caching.
    • EDM Pool Monitoring and Tuning.
  8. Log Buffers
    • Commit Processing.
    • Forward Recovery and Rollback.
    • Active Log, Archive Log, and BSDS.
    • Checkpoints.
    • Fast Log Apply.
    • Monitoring and Tuning DB2 Logging.
  9. Transaction Locking
    • Lock Size, Mode, and Duration.
    • Tablespace Locks.
    • Page and Row Locks.
    • Lock Avoidance.
    • Page Latching, C_LSN, and PUNC.
    • IRLM.
    • Locking Parameters.
    • LOB Locking.
    • Monitoring and Tuning Locking.
  10. Other Serialisation Mechanisms
    • Partition Independence.
    • Claim and Drain.
    • Restrictive States.
    • Monitoring Claim and Drain.
  11. DB2 Attachments
    • The TSO, CICS, IMS, and Call Attaches.
    • Two Phase Commit.
    • Monitoring and Tuning the Attaches.
  12. DDF, SPs, and UDFs

  13. Utilities and Special Processes
    • Utility Serialisation.
    • Load, Reorg, Copy, Recover, and Runstats.
    • Monitoring Utilities.
    • DB2 Catalog and Directory.
  14. Other I/O Issues
    • Dataset Placement and Cache.
    • Pageset Open and Close.
    • I/O Scheduling Priority.
MT/04

© 2007 Verhoef Training, Inc.