DB2 for z/OS Performance Monitoring Masterclass 2016

Julian Stuhler, Triton Consulting - Tuesday 19 April - Session 2

Application monitoring and tuning has always been key to meeting critical service level objectives, and this will remain the case despite the increasing sophistication of the DB2 optimizer. This seminar provides a comprehensive review of the best techniques for monitoring and tuning DB2 applications, and has been full updated for DB2 11 for z/OS.

Although the class uses on IBM’s Omegamon XE for DB2 tool as an example, the reports and monitoring techniques that are covered apply to all DB2 for z/OS environments. The seminar includes several real-world case studies for common application and system performance problems, showing how good monitoring practices can help to rapidly diagnose and resolve common DB2 performance issues.


  • An Introduction To DB2 Performance
    • Performance Management Concepts
    • DB2 Component Review
    • So What Could Possibly Go Wrong?
  • DB2 Performance Traces
    • Trace Overview
    • The Accounting Trace
    • The Statistics Trace
    • The Performance Trace
    • Other Traces
    • The Instrumentation Facility Interface (IFI)
    • Trace Management
  • DB2 PM Reports
    • Introduction To DB2 Monitoring Tools
    • Generating DB2 Reports
    • The Accounting Report Set
    • The Statistics Report Set
    • Performance Report Sets
    • Other Reports
  • Application Performance Monitoring & Tuning
    • Overview
    • Five Case Studies
  • System Performance Monitoring & Tuning
    • Overview
    • Intra-system Monitoring & Tuning
    • Inter-system Monitoring & Tuning
    • DB2 PM Online Monitoring & Exception Reporting
    • Online v Batch Monitoring
    • DB2 Online Monitoring
    • DB2 Exception Reporting
  • Pulling It All Together
    • The Holistic Approach To Performance
    • An Ideal Performance Management Environment
  • Conclusion & Summary

Platform: z/OS


← Back to all sessions

About: Julian Stuhler


Julian is an IBM Gold Consultant, and Principal Consultant with Triton Consulting. He has over 25 years DB2 experience working with many customers throughout Europe and the United States. In that time he has gained a significant amount of practical knowledge in many aspects of the DB2 Family, including experience in application programming, Database Administration, technical architecture, performance tuning and systems programming.

Julian is an IBM Redbook author, an IDUG Best Speaker, and has lectured widely on DB2 subjects in many countries for IDUG, IBM and vendor events. He is also a regular teacher for IBM throughout Europe.

In May 2008, Julian was named as one of IBM's inaugural Data Champions and has been recognised in that capacity each year since. Julian served on the IDUG Board of directors from 2003 to 2010, and is an IDUG Past President.