View Printable Version
Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace
Full Day Seminars
John Campbell [IBM DB2 for z/OS Development]
Tycho => Fri, Nov 18, 2011 (09:00 AM - 05:00 PM)
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:
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)
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.
Understand the key performance indicators to be monitored
Provide rules-of-thumb to be applied
Understand how to investigate with more detailed tracing and analysis
Provide tuning advice for common problems
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.