Quantification
Each report line shows the following for each Correlation ID and,
when expanded, for each SQL statement observed for the Correlation
ID.
- Number of SQL calls
- Total task CPU time for the SQL call processing
- Mean SQL call task 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 the task 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.