DB2 Performance & Tuning for Production DBAs

Course Code: DZOPTP
Duration: 4 days
Environment: Non-data sharing
Audience: Production DBAs, Capacity Planners, Database Administrators and System Administrators.
Prerequisites: A working knowledge of DB2 objects, architecture and basic SQL.
Summary: This course is designed mainly for DB2 Production DBAs in particular and DB2 DBAs in general. It imparts the necessary knowledge to monitor and tune areas that have a medium-to-high impact on DB2 subsystem performance:
  • Application and SQL design
  • DB2 subsystem and operating system dependencies
  • Workloads in terms of threads, etc.
  • Data set placement and management
  • Index design and usage
  • Buffer pool usage
  • Locking and concurrency
  • Controlling sorts
  • Batch application design
  • Online (CICS) application design
Objectives: Upon completion of this presentation, the participant should be able to use DB2 related accounting, statistics and EXPLAIN reports to monitor and tune:
  • SQL
  • Index usage and design
  • The DB2 subsystem in general
  • The DB2 I/O subsystem
  • The DB2 buffer pools
  • Sort pools
  • IRLM (lock manager)
  • Applications
View full outline in PDF formatDetailed Outline Bookmark and Share

Course Schedule

Request a date for this course

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page