Quantification

Each report line shows the following for each Requester Location and, when expanded, for each SQL statement observed for the Requester Location.
  • 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. Remember 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. This is reflected in the enclave CPU times shown in the detail windows of this report.