Quantification

Each report line shows the following for each SQL statement:

• 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 service time per SQL call, 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.