DB2 System Tuning 2009

Objectives:
Gain more insight in the way DB2 works and obtain skills to analyze performance data in order to make the right decision for system tuning.

Outline:
 How to do tuning and monitoring
 CPU resource
       TCB / SRB / ZIIP Concept
       Where various CPU type are used
       Thread CPU breakdown
       Types of parallelism and when (not) used
       Stored Procedures
 Memory resources
       Virtual v.s. Physical
       Signs of Stress
       DB2 Buffer Pools
       DB2 EDM Pool 
       DB2 Sort Pool
       DB2 RID Pool
       Other DB2 Memory areas
       Impact of DB2 V8 on memory tuning

I/O Efficiency
       Signs of stress
       Logging and how to improve
       Does dataset placement & extents matter
       using VSAM Striping
       Impact of FICON and PAV
       Compression

Full Abstract:
The more you understand how DB2 is internally structured, the easier it will be to do system tuning. This presentation will teach you the different components that make up DB2 for z/OS. With every part we examine, we also will look how we can tune this component to achieve maximum performance. This seminar is unique since it focuses completely on the system side of DB2. Once you know how DB2 services your requests you also will find it easier to understand application tuning and the recent DB2 enhancements. The target audience is people who have multiple years of experience with DB2 and who want to learn more about the internal structure of DB2. During previous presentation at the DB2 Symposium this seminar was rated with 8.2 on average!