DB2 System Tuning 2009

Date: 
Thursday, 18 June, 2009 (All day)
Speaker: 
Klaas Brant

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!

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020