Times - Class 2 - Time Distribution

This topic shows detailed information about Accounting - Times - Class 2 - Time Distribution.

The class 2 time distribution block shows the distribution of the active-in-DB2 time, the not-accounted time, and the suspension time, of the originating task. For threads exploiting query parallelism, only the nonparallel part is taken is taken into account.

The following example applies to both, the report layout and the trace layout.

Accounting - Times - Class 2 - Time Distribution

The field labels shown in the following sample layout of Accounting - Times - Class 2 - Time Distribution are described in the following section.


CLASS 2 TIME DISTRIBUTION
----------------------------------------------------
CPU    |==================> 37%
SECPU  |===> 7%
NOTACC |
SUSP   |============================> 56%

CPU

The ratio of the agent DB2 CPU time, expressed as a percentage of the DB2 elapsed time.

Field Name: ARATCPU

SECPU

The ratio of the agent DB2 SE (IBM specialty engine) CPU time, expressed as a percentage of the DB2 elapsed time.

Field Name: ARATCSE

NOTACC

The ratio of the DB2 not accounted time, expressed as a percentage of the DB2 elapsed time.

Field Name: ARATNAC

SUSP

The ratio of the agent DB2 suspension time, expressed as a percentage of the DB2 elapsed time.

Field Name: ARATSUP