DB2 Subsystem Performance Tuning

Duration:4 days (non-data sharing)
5 days (including data sharing)Audience:Database Administrators, System Administrators and Capacity Planners.Prerequisites:A working knowledge of DB2 objects and architecture.Summary:This course places particular emphasis on the monitoring, performance and tuning of the DB2 for z/OS subsystem. This includes:

• The DB2 workload assessment
• Response times and throughput
• Buffers, EDM, RID and Sort pools
• Threads
• Data set placement/management
• Locking & concurrency
• IRLM
• Logging
• Database Services Address Space (DBM1) optimisation
• CICS considerations
• Data sharing considerations (5th day – optional)

Central to tuning the above-listed facilities are the accounting and statistics reports and DB2 commands (e.g., -DISPLAY BUFFER/THREAD).Objectives:Upon completion of this presentation, the participant should be able to:

• Plan performance tuning
• Determine which tools to use
• Measure system performance
• Determine if subsystem will be cost-effective
• Determine the cause of performance problems
• Decide when and what to tune
• Interpret relevant accounting and statistics reports
• Tune DB2 subsystem facilities

Lab:Numerous exercises involving accounting reports, statistics reports and command displays.