Using an Accounting report to analyze resource activities

The Accounting report shows how threads and applications perform in Db2.

The Accounting report set consists of a report and a trace report. The Accounting report accumulates and groups Accounting records by OMEGAMON for Db2 PE identifiers, such as primary authorization or plan name. The Accounting trace report reports single threads. A trace report can be very long because it shows a single record for each active thread in the system.

A good first indicator for applications is the time used per thread by any particular user. A strategy to improving application performance is to identify the users with the most system time consumption and examine their most frequently used applications:

  • Create a Db2 trace for input to a report
  • Create a short Accounting report that identifies the users with the highest system time consumption.
  • Interpret the report and identify users and plans that need attention
  • Create an Accounting trace report for each problem user and plan
  • Interpret the trace report and find remedial actions
  • Apply rules of thumb in the Performance Warehouse