Package General (Short Report)

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

Accounting - Package General (Short Report) 


...
----------------------------------------------------------------------------------------------------------------
|PROGRAM NAME        TYPE      #OCCURS  #ALLOCS  SQLSTMT  CL7 ELAP.TIME   CL7 CPU TIME  CL8 SUSP.TIME  CL8 SUSP|
|PKGNAME             PACKAGE      1164     1164     4.15       0.047610       0.009510       0.023908      4.47|
----------------------------------------------------------------------------------------------------------------
...

The fields shown in this record block are described below. Db2 field names are shown in brackets next to each report field.

PROGRAM NAME [QPACPKID]

(Exception field) 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*.

TYPE [ADPCKTYP]

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.

#OCCURS [ADTOTPOC]
This value can be one of the following:
  • In general, the total number of accounting trace sections for a package or DBRM regardless of enabled or disabled Db2 trace classes 7 and 8 at the time of writing the trace record. In case of Distributed Data Facility (DDF) or Recoverable Resource Manager Services Attach Facility (RRSAF) threads, it is the number of accounting intervals rolled up in a record.
  • If REPORT ORDER (ACTNAME) is specified, the total number of package sections of a special activity type depends on the following:
    • If IFCID 233 or 380 is available, stored procedures (SP) are counted based on the available IFCID. If both IFCIDs are available, IFCID 380 is the preferred one for SP reporting. Subprograms called by these SPs are not taken into account.
    • If IFCID 233 or 381 is available, user-defined functions (UDF) are counted based on the available IFCID. If both IFCIDs are available, IFCID 381 is the preferred one for UDF reporting. Subprograms called by these UDFs are not taken into account.
    • If neither IFCID 233, 380, nor 381 is collected, all packages of an activity type are counted. The sum also includes the number of subprograms.
#ALLOCS [APACSWIT]

This value can be one of the following:

  • In general, the number of times a package was invoked by a different package. For the first package run by an application, the initial call counts as a package switch. If this package called a nested package (such as a trigger, UDF, or stored procedure), a switch will not be counted upon return from such a package.
  • If REPORT ORDER (ACTNAME) is specified, the number of times a package of a special activity type is invoked from a different package depends on the following:
    • If IFCID 233 or 380 is available, the invocations of stored procedures (SP) are counted based on the available IFCID. If both IFCIDs are available, IFCID 380 is the preferred one for SP reporting. Subprograms called by these SPs are not taken into account.
    • If IFCID 233 or 381 is available, the invocation of user-defined functions (UDF) are counted based on the available IFCID. If both IFCIDs are available, IFCID 381 is the preferred one for UDF reporting. Subprograms called by these UDFs are not taken into account.
    • If neither IFCID 233, 380, nor 381 is collected, all invocations of an activity type are counted. The sum also includes the number of subprograms.
SQLSTMT [QPACSQLC]

(Exception field) 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:
CL7 ELAP.TIME [QPACSCT]

(Exception field) The total elapsed time for executing the package or DBRM.

CL7 CPU TIME [ADCPUTP]
(Exception field) 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.

CL8 SUSP.TIME [ADTSUSTP]

(Exception field) The waiting time for the package or DBRM due to class 8 suspensions.

CL8 SUSP [ADTSUSCP]

(Exception field) The number of all types of class 8 suspensions.