View Printable Version

Understanding DB2 for z/OS Accounting Trace Information

Session Number: 4017
Track: DB2 for z/OS
Session Type: Podium Presentation
Primary Presenter: John Campbell [Distinguished Engineer - IBM DB2 for z/OS Development]
Time(s):
Tue, Sep 15, 2015 (09:00 AM - 05:00 PM)

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: Understand the sources of key performance indicators

Objective 2: Know how to determine where a DB2 transaction is spending its time?

Objective 3: Distinguish clearly between CPU vs. suspension time

Objective 4: Understand most common reasons for large suspension times

Objective 5: Provide rules of thumb, and tuning hints and tips
Co-speaker Name: Florence Dubois

Abstract:  This one day seminar provides in-depth education on how to use the DB2 accounting trace to troubleshoot applications which are performing badly, to understand where the time is actually spent, what DB2 resources are utilized, and how to tune. The following topics will be covered: DB2 traces: sources of key performance indicators, where is a DB2 transaction spending its time?, CPU vs. suspension time, most common reasons for large suspension times,
SQL / Locking / bufferpool / group bufferpool accounting counters, hints and tips for tuning.

For questions or concerns about your event registration, please contact aucpc@idug.org