Quantification

Each report line shows the following for each DB2® Plan and, when expanded, for each SQL statement observed under the Plan.
  • Number of SQL calls.
  • Total CPU time for the SQL call processing.
  • Mean SQL call CPU time, or percent of total used.
  • Total service time for the SQL call processing.
  • Mean SQL call service time, or percent of total used.

A setup option is available to display the percent used in place of the mean fields. Keep in mind that measured CPU time applies only to the region being measured. DB2 executes in multiple address spaces and CPU could also be consumed in other DB2 regions not reflected in this report. For DDF only, this is reflected in the enclave CPU times shown in the detail windows of this report.

Parent topic: F12 - DB2 SQL CPU/Svc time by plan