Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace
Session Number: 1881
Track: Full Day Seminars
Session Type: Podium Presentation
Primary Presenter: John Campbell [IBM DB2 for z/OS Development]
Speaker Bio: John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive experience of DB2 in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.
Audience experience level: Intermediate, Advanced
Presentation Category: Managing Performance
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Database Administrators, Systems Programmers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS)
Objective 1: Introduce and discuss the key areas of system performance: system address space CPU, EDM pools, dataset activity, logging, lock/latch contention, DBM1 virtual and real storage, buffer pool and GBP, DIST (DDF) activity etc.
Objective 2: Understand the key performance indicators to be monitored
Objective 3: Provide rules-of-thumb to be applied
Objective 4: Understand how to investigate with more detailed tracing and analysis
Objective 5: Provide tuning advice for common problems
Abstract: This one day seminar will focus on the key areas of system performance - dataset activity, buffer pool and GBP, lock/latch contention, system address space CPU, EDM pool, RID pool, DBM1 virtual and real storage etc. Information will be provided on key performance indicators to be monitored and the rules of thumb to be applied in each area. Information will be provided on what more detailed tracing and analysis is required. Tuning advice will be provided for common problems.
For questions or concerns about your event registration, please contact firstname.lastname@example.org