Understanding Db2 for z/OS accounting information - "The full monty"

Bart Steegmans, IBM Corporation - Thursday 16 May - Session 1
 

DB2 Accounting data is the single most important source of information to track Db2 application performance and almost everybody gathers Db2 accounting information. But do you also use, understand and exploit all the information that is in those records? This on day seminar will explain what information is tracked by Db2 and stored in its accounting records, and what all (or at least most of) the fields mean, including the data sharing related sections.

Topics:

  • We will discuss how to analyze transaction response time as seen by Db2, and transaction performance in general, as well as how to exploit this great source of information to analyze and solve performance problems.
  • We will also explore what additional trace data you can collect in case the DB2 accounting information does not provide enough information to determine the root cause of a problem.
  • And last but not least, the latest and greatest instrumentation enhancements in this area that come with Db2 11 and Db2 12 for z/OS will also be discussed.

Platform: z/OS

logo

← Back to all sessions

About: Bart Steegmans

photo

Bart Steegmans is a consulting Db2 for z/OS Product Support Specialist from IBM Belgium, currently working remotely for the IBM Silicon Valley Laboratory in San Jose, providing technical support for DB2 for z/OS performance problems. He has 30+ years of experience in DB2. Before joining IBM in 1997, Bart worked as a DB2 system administrator at a banking and insurance group. His areas of expertise include Db2 performance, database administration, and backup and recovery.
Bart is a co-author of numerous IBM Redbooks publications on Db2 for z/OS, including Db2 12 for z/OS Performance Topics.

logo

Have questions? Search our knowledgebase.