Package General (Short Trace)

This topic shows detailed information about Accounting - Package General (Short Trace).

This block is part of the Accounting Short Trace.

Accounting - Package General (Short Trace)

The field labels shown in the following sample layout of Accounting - Package General (Short Trace) are described in the following section. 


...
----------------------------------------------------------------------------------------------
|PROGRAM NAME        TYPE      SQLSTMT  CL7 ELAP.TIME   CL7 CPU TIME  CL8 SUSP.TIME  CL8 SUSP|
|PKGNAME             PACKAGE         4       0.184705       0.003055       0.041534         4|
----------------------------------------------------------------------------------------------
...
PROGRAM NAME

The program name (package ID or DBRM name).

In the case of rollup data (Accounting data of DDF/RRSAF threads and parallel tasks accumulated by DB2), the following value is shown *ROLSUM*.

Field Name: QPACPKID

This is an exception field.

TYPE

An indicator of whether the block describes a package or a DBRM. Possible values are PACKAGE, DBRM, and BOTH. BOTH can be shown in reports if there are packages and DBRMs with the same program name.

Field Name: ADPCKTYP

SQLSTMT

The number of SQL statements issued in this package or DBRM.

This number may not be equal to the total number of SQL statements in the QXST data section because QXST does not count all SQL statements. For example, it does not count commit or rollback statements.

Note: This field is shown for the following field labels in Accounting trace:
  • SQL STMT - TOTAL
  • SQL STMT - AVERAGE:

Field Name: QPACSQLC

This is an exception field.

CL7 ELAP.TIME

The total elapsed time for executing the package or DBRM.

Field Name: QPACSCT

This is an exception field.

CL7 CPU TIME
The class 7 CPU time spent by the package or DBRM. It indicates:
  • The TCB time
  • The accumulated CPU time for processing parallel tasks. This is valid for query CP parallelism, sysplex query parallelism, and parallel tasks generated by utilities.

In sysplex query parallelism, only CPU times of parallel tasks, running on the same member of the sysplex group as the originating task, are included.

This time does not include the CPU time consumed on an IBM specialty engine.

Field Name: ADCPUTP

This is an exception field.

CL8 SUSP.TIME

The waiting time for the package or DBRM due to class 8 suspensions.

Field Name: ADTSUSTP

This is an exception field.

CL8 SUSP

The number of all types of class 8 suspensions.

Field Name: ADTSUSCP

This is an exception field.