Package (BACCTDR)
This topic describes the Package section of the Accounting summary—long report (BACCTDR).
PACKAGE TOTALS CPU AND ELAPSED TIMES SUSPEND WAIT TIMES EVENTS WAIT TIME/EVENT
-------------------------------- ------------------------------- -------------------------------- ------- ---------------
PACKAGE SECTION CNT 102 CL7 ELAPSED TIME 00:00.093951 LOCK 00:00.000000 0 N/P
DBRMS 0 CL7 CPU TIME 00:00.002428 LATCH 00:00.000000 0 N/P
STORED PROCEDURES 0 CL7 SE CPU TIME 00:00.000000 SYNCHRONOUS I/O 00:00.001662 0 0.006759
USER DEFINED FCNS 0 OTHER READ I/O 00:00.000150 0 0.023155
TRIGGERS 0 CL8 SUSPEND TIME 00:00.016049 OTHER WRITE I/O 00:00.000000 0 N/P
NATIVE ST PROCS 0 NOT ACCOUNTED 00:00.075473 SERV TASK SWITCH 00:00.014237 1 0.016601
NON-INLINE UDFS 0 ARCH LOG(QUIESCE) 00:00.000000 0 N/P
TOTAL EXECUTIONS 309 CPU SERVICE UNITS 88.09 ARCHIVE LOG READ 00:00.000000 0 N/P
SE CPU SERV UNITS 0.00 DRAIN LOCK 00:00.000000 0 N/P
STOR PROCS CALLED 0 CLAIM RELEASE 00:00.000000 0 N/P
UDFS SCHEDULED 0 PAGE LATCH 00:00.000000 0 N/P
NOTIFY MESSAGE 00:00.000000 0 N/P
TOTAL SQL STMTS 1851 SQL STATEMENTS AVG 6 GLOBAL CONTENTION 00:00.000000 0 N/P
TOTAL DB2 ENT/EXIT 1554 DB2 ENTRY/EXIT AVG 5 TCP/IP LOB 00:00.000000 0 N/P
TOTAL SUCC AUTH CHK 98 SUCC AUTH CHK AVG 0 ALL CL8 SUSP TYPES 00:00.016049 1 0.014458
The following table describes the fields in the Package section.
Field | Description |
|---|---|
PACKAGE SECTION CNT | Number of Package Program name (Count of QPACPKID) |
DBRMS | Number of Program Type (Package/DBRM) (QPACTYPE) |
STORED PROCEDURES | Number of Stored Procedures (QPACAAFG) |
USER DEFINED FCNS | Number of User Defined Functions (QPACAAFG) |
TRIGGERS | Number of Triggers executed (QPACAAFG) |
NATIVE ST PROCS | Number of Native SQl Stored Procedure (QPACAAFG) |
NON-INLINE UDFS | Number of Non-inline UDFS (QPACAAFG) |
TOTAL EXECUTIONS | Total Number of Package executions |
STOR PROCS CALLED | Number of Stored Procedures Executed (QPACSPNS) |
SQL STATEMENTS AVG | Number of SQL statements issued in this package or DBRM (QPACSQLC) |
TOTAL SQL STMTS | SQL request count (QPACSQLC) This number is the total number of SQL statements executed from this package or DBRM, including COMMIT or ROLLBACK statements. Tuning Tip: This field assists you in determining which packages are more SQL intensive. The totals for packages may not equal the totals in the accounting section because of differences in the counters such as commits and rollbacks. |
TOTAL SUCC AUTH CHECK | For Accounting reports, the number of times authorization information was found for this package without accessing the DB2 catalog (QPACPAC) |
CL7 ELAPSED TIME | Elapsed time of a package/DBRM execution (QPACSCT) This time represents the average elapsed time of all executions of this package or DBRM. Accounting class 7 must be active to gather this data. Tuning Tip: This information can provide more granular information as to which package or DBRM consumed the most resources. |
CL7 CPU TIME | Class 7 CPU time spent by the package or DBRM It indicates the average TCB time or the average accumulated CPU time for processing parallel tasks. This is valid for query CP parallelism, sysplex query parallelism, and parallel tasks generated by utilities. |
CL7 SE CPU TIME | Average accumulated WAIT used for DBRM on ZIIP. This time indicates the average CPU time for all executions of this package consumed on ZIIP |
SE CPU SERV UNITS | Average CPU Service unit time for package. It indicates the average CPU time for all executions of a package consumed on ZIIP |
SUCC AUTH CHK AVG | Average SUCC AUTH Checks. It indicates the average number of times authorization information was found for the package without accessing the DB2 catalog. |
SUSPENSIONS-CL8 | Average wait time for the package or DBRM due to class 8 suspensions |
NOT ACCOUNTED | Average unaccounted time in DB2 due to the execution of the package or DBRM In query CP and Sysplex query parallelism, it is the unaccounted time of the originating task only. |
DB2 ENTRY/EXIT AVG | Number of DB2 entries or exits processed during the execution of the package or DBRM |
TOTAL DB2 ENTRY/EXIT | Number of DB2 entries or exits processed during the execution of the package or DBRM |
CPU SERVICE UNITS | CPU service unit time for a package or DBRM. It indicates the TCB time or the accumulated time for processing parallel tasks if query CP or Sysplex query parallelism is exploited |
LOCK | Average Wait time for lock This value indicates the average elapsed time the thread waited for transaction locks while executing a package/DBRM. Accounting class 8 must be activated to determine this value. Tuning Tip: This time reflects the average amount of time the thread was suspended because of an incompatible lock mode. |
LATCH | Average Wait time for latch This value indicates the average elapsed time the thread waited for transaction latch while executing a package/DBRM. Accounting class 8 must be activated to determine this value. Tuning Tip: This time reflects the average amount of time the thread was suspended because of an incompatible latch mode. |
SYNCHRONOUS I/O | Average number of wait trace events processed for waits for synchronous I/O under this thread while executing this package or DBRM |
OTHER READ I/O | Average Wait time for asynchronous reads |
OTHER WRITE I/O | Average Wait time for write I/O |
EXECUTION TASK SWITCH | Wait time for DB2 services This value is the average time spent waiting for special DB2 services while executing this package/DBRM. A synchronous execution unit switch is done from the thread to one of the DB2 service tasks. Accounting class 8 must be activated to obtain this time. Service times reported here include:
|
ACTIVITY TYPE | For nested activity, values shown are STORED PROC, TRIGGER, UDF; otherwise, NONNESTED is shown (QPACAAFG) 01 = StorProc 02 = UDF 03 = Trigger All others = non-nested |
ACTIVITY NAME | Name of the nested activity (QPACAANM) |
SCHEMA NAME | Schema name of the nested activity (QPACASCH) |
ARCHIVE LOG QUIESCE | Average wait time for log quiesce This value is the average time spent waiting for an -ARCHIVE LOG MODE(QUIESCE) to take place while executing this package/DBRM. This process externalizes buffers and switches the active log data set. Time reflected here is the time the thread waited, not the time for the command to complete. Accounting class 8 must be activated to obtain this time. |
ARCHIVE LOG READ | Average wait time for archive read from tape This value is the average amount of time spent waiting for reads from an archive tape while executing this package/DBRM. Time spent waiting for an archive tape is either for the completion of the RECOVER utility or for an application program, which has not committed, to read the archive tape in order to complete backout. Accounting class 8 must be activated to obtain this time. |
UDF SCHEDULE | Number of user-defined functions scheduled (QPACUDNU) |
DRAIN LOCK | Average wait time for drain lock This value is the average time spent by a requester of a drain lock, such as a utility or command, waiting to acquire that lock while executing this package/DBRM. Processes, such as utilities that serialize events to page sets, must acquire a drain lock. This value is the time spent waiting for this event. Accounting class 8 must be activated to obtain this time. |
CLAIM RELEASE | Average wait time for claim release This value is the average time spent by the holder of a drain lock waiting for SQL claimers to complete their activity while executing this package/DBRM. Drainers must wait until the SQL claim count reaches zero. This value is the time spent waiting for them to clear. Accounting class 8 must be activated to obtain this time. |
PAGE LATCH | Average wait time for page latch contention This value is the average time spent waiting for page latching activities due to lock avoidance while executing this package/DBRM. Accounting class 8 must be activated to obtain this time. |
NOTIFY MESSAGE | Average wait time for data sharing notify messages This value is the average amount of wait time for sending notify messages to another data sharing member while executing this package/DBRM. When tables in a data sharing group are CREATed, ALTERed, or DROPped in a data sharing group, intersystem messages must be sent to update the database descriptors (DBDs) in the other members’ EDM pools. This value is the average time spent waiting for this message traffic to occur. This time is collected only when accounting class 8 is activated and data sharing is enabled. |
GLOBAL CONTENTION | Average wait time for global lock contention This time is the average amount of elapsed time caused by an IRLM lock suspension due to global lock contention while executing this package/DBRM. It requires intersystem communication to resolve. This time is collected only when accounting class 8 is activated and data sharing is enabled. |
TCP/IP LOB | Average accumulated wait time for TCP/IP LOB |
TOTAL CL8 SUSPENDS | All class 8 wait times In the DB2 Accounting Package Report, this value is the total time the program spent waiting for all types of suspensions (QPACAWTL+QPACAWTI+QPACAWTR+QPACAWTW+ QPACAWTE+ QPACALOG+QPACAWDR+QPACAWCL+QPACAWTP+QPACAWAR+ QPACAWTG+QPACAWTK+QPACAWTM+QPACAWTN+QPACAWTO+QPACAWTQ+ QPACAWTJ+QPACCAST+QPACUDST). |
Related topic