Thread Package Summary

Use these attributes to view the detailed thread package summary statistics.

Accelerator Events Number of wait trace event processed that were processed for requests to an accelerator while this package was executing. (Field name: QPACAACC).

Accelerator Wait Time Accumulated wait time for requests to an accelerator while this package was executing. (Field name: QPACAACW).

Activity Name %U activity name. (Field name: ADPAANM).

Activity Type Activity flag: 01: Storage procedure, 02: User-defined function, 03: Trigger, 04: Native SQL procedure, 05: Non-inline user-defined function. (Field name: ADPATYP).

Archive Log Events Number of suspensions due to processing of archive log mode (QUIESCE) commands during execution of the package. (Field name: QPACALCT).

Archive Log Wait Time Accumulated wait time due to processing of archive log mode (QUIESCE) commands during execution of the package or DRBM. (Field name: QPACALOG). This number represents the amount of time that an individual thread was suspended due to an archive log mode (QUIESCE) command, and not the time that was required for the entire command to complete.

Archive Read Events Number of wait trace events processed for the following events during execution of the package: Archive log reads, Active log reads, and Active log prefetch reads. (Field name: QPACANAR).

Archive Read Wait Time Accumulated wait time for the following events during execution of the package: Archive log reads, Active log reads, and Active log prefetch reads. (Field name: QPACAWAR).

Authchk Without Catalog X'0040': Successful authorization checking occurred without Db2 catalog access. (Field name: QPACPAC).

Claim Release Events Number of wait trace events processed for suspensions for waiting for claims to be release during execution of the package. (Field name: QPACARNC).

Claim Release Wait Time Accumulated wait time for a drain during a wait for claims to be released during execution of the package. (Field name: QPACAWCL).

Child L-locks Accumulated wait time due to global contention for child L-Locks. (Field name: QPACAWTK).

Child L-locks Events Number of wait trace events processed for waits due to global contention for child L-Locks. (Field name: QPACARNK).

Class 7 times captured X'0020': There is non-zero, accounting Class 7 data in this QPAC data instance. (Field name: QPACCLS7).

Class 8 Times captured X'0004': There is non-zero, accounting Class 8 data in this QPAC data instance. (Field name: QPACCLS8).

Consistency Token %U consistency token. %U if QPACCONT_OFF is not 0, this value is truncated. (Field name: QPACCONT).

CP CPU Time CP CPU time. (Field name: ADCPUTP).

CPU Time at Entry CPU time at entry to Db2 for the most recent execution of the package. This time does not include CPU time that is consumed on an IBM specialty engine. (Field name: QPACBJST).

CPU Time at Exit CPU time at exit from Db2 for the most recent execution of the package. This time does not include CPU time that is consumed on an IBM specialty engine. (Field name: QPACEJST).

CPU zIIP Time Total CPU time for all executions of the package that were consumed on an IBM specialty engine. (Field name: APACC7Z).

Data for current package X'0008': This data is for the current or most recently executed package. (Field name: QPACCRNT).

Data Sharing Group The data sharing group name. (Field name: GROUP).

Db2 Entry/Exit events Number of Db2 entry or exit events that were processed during execution of the package. (Field name: QPACARNA).

DB2 Subsystem The Db2 subsystem ID. (Field name: DB2ID).

DB2 Version The Db2 version. (Field name: DB2VER).

Drain Lock Events Number of wait trace events processed for waits for drain locks during execution of the package. (Field name: QPACARND).

Drain Lock Wait Time Accumulated wait time for a drain lock during execution of the package. (Field name: QPACAWDR).

DSG Member Name The data sharing group member name. (Field name: MEMBER).

Elapsed Time Current Current elapsed time. (Field name: ADELCL7C).

Elapsed Time Total Total elapsed time that was used for processing all executions of the package. (Field name: QPACSCT).

Entry to Db2 Time Store clock value at entry to Db2 for the most recent execution of the package. (Field name: QPACSCB).

Exit from Db2 Time Store clock value at exit from Db2 after the most recent execution of the package. (Field name: QPACSCE).

Incompatible function X'0080': The package has an incompatible function. IFCID 0366 and 0376 have information about the incompatible function. (Field name: QPACINCO).

Interval Start The start time of this interval. (Field name: TIMESTAMP).

Latch events Number of wait trace events processed for waits on latches during execution of the package. (Field name: QPACANLH).

Latch wait time Accumulated wait time due to latch suspensions during execution of the package. (Field name: QPACAWLH).

Loaded by SP X'0010': The package was loaded by a stored procedure. (Field name: QPACINSP).

Location Name %U location name. (Field name: QPACLOCN). If this name identifies a remote site, %U all times represent the amount of time that was used %U locally to execute the package at the remote site. %U if QPACLOCN_OFF is not 0, this value is truncated.

Lock Wait Events Number of wait trace events that were processed for waits for a lock during execution of the package. (Field name: QPACARNL).

Lock Wait Time Accumulated lock elapsed wait time during execution of the package. (Field name: QPACAWTL).

MVS System ID The MVS identifier. (Field name: MVSID).

Not Accounted Not accounted time. (Field name: ADNACL7T).

Notify Messages Events Number of wait trace events processed for messages within the Db2 data sharing group. (Field name: QPACARNG).

Notify Msg Wait Time Accumulated wait time due to sending of messages within the Db2 data sharing group. (Field name: QPACAWTG).

Originating System The managed system name of the agent. Valid format is alphanumeric, with a maximum of 32 characters; example, DB91:SYS1:DB2. (Field name: ORIGINNODE).

Other Read I/O Accumulated wait time for read I/O that is done under a thread other than the thread associated with the package during execution of the package. (Field name: QPACAWTR).

Other Read I/O Events Number of wait trace events processed for waits for read I/O under another thread during execution of the package. (Field name: QPACARNR).

Other L-locks Accumulated wait time due to global contention for other L-Locks. (Field name: QPACAWTM).

Other L-locks events Number of wait trace events processed for waits due to global contention for other L-Locks. (Field name: QPACARNM).

Other P-locks Accumulated wait time due to global contention for other P-Locks. (Field name: QPACAWTQ).

Other P-locks events Number of wait trace events processed for waits due to global contention for other P-Locks. (Field name: QPACARNQ).

Other Write I/O Events Number of wait trace events processed for waits for write I/O under another thread during execution of the package. (Field name: QPACARNW).

Other Wrt I/O Wait Time Accumulated wait time for write I/O that is done under a thread other than the thread associated with the package during execution of the package. (Field name: QPACAWTW).

Package Collection ID %U package collection ID. %U if QPACCOLN_OFF is not 0, this value is truncated. (Field name: QPACCOLN).

Package switches Number of times that a package was invoked from a different package. (Field name: QPACSWCH). For the first package that is run by an application, the initial call counts as a package switch. If this package calls a nested package (trigger, user-defined function, or stored procedure), return from the nested package does not count as a switch.

Page Latch Events Number of wait trace events processed for page latch contention during execution of the package. (Field name: QPACARNH).

Page Latch Wait Time Accumulated wait time due to page latch contention during execution of the package. (Field name: QPACAWTP).

Page P-locks Accumulated wait time due to global contention for page P-Locks. (Field name: QPACAWTO).

Page P-locks events Number of wait trace events processed for waits due to global contention for page P-Locks. (Field name: QPACARNO).

Parent L-locks events Number of wait trace events processed for waits for global lock contention for parent L-Locks. (Field name: QPACARNJ).

Parent L-locks wait time Accumulated wait time due to global contention for parent L-Locks.(Field name: QPACAWTJ). Global contention occurs when inter-system communication is required to resolve an IRLM lock or change request. QPACAWTL contains the wait time due to local contention. Local contention does not require inter-system communication. It can be resolved by the local subsystem.

Pipe events Number of wait trace events that were processed for waits for a pipe while this package was being executed. (Field name: QPACPIPC).

Pipe wait time Accumulated wait time for a pipe while this package was being executed. (Field name: QPACPIPW).

Pgs/part P-locks evt Number of wait trace events processed for waits due to global contention for page set or partition P-Locks. (Field name: QPACARNN).

Pgs/partition P-locks Accumulated wait time due to global contention for page set or partition P-Locks. (Field name: QPACAWTN).

PQ Sync Events Number of times that waits for parallel query processing to synchronize parent and child tasks were suspended. (Field name: QPACPQSC).

PQ Sync Wait Time Accumulated wait time for parallel queries to synchronize parent and child tasks. (Field name: QPACPQSW).

Program Name %U if QPACPKID_OFF is not 0, this value is truncated. (Field name: QPACPKID).

ROLLUP QPAC X'0001': This is a rollup QPAC record. (Field name: QPACROLL).

Schema Name %U nested activity schema name. (Field name: ADPASCH).

Section number The number of this DSNDQPAC data section in the series of DSNDQPAC data sections that might be externalized in this trace record. (Field name: QPACRECN). QWACPKGN and QPKGPKGN identify the number of packages for which package accounting has been performed.

Server Task Switch Evt Number of wait trace events processed for waits for synchronous execution unit switching to Db2 service tasks during execution of the package. (Field name: QPACARNS).

SP executed Number of stored procedures executed. (Field name: QPACSPNS).

SQL Statements executed The number of SQL statements that were issued. (Field name: QPACSQLC). This field might not equal the total of all SQL statement counters in the QXST data section, because the QXST counters do not count all SQL statements. For example, QXST does not include a counter for commit or rollback statements.

Summary ROLLUP X'0002': This is a summary rollup QPAC record. The data in this QPAC record is an accumulation of data from one or more unspecified packages. (Field name: QPACRUSM).

Sync I/O Events Number of wait trace events that were processed for waits for I/O under the associated thread during execution of the package. (Field name: QPACARNE).

Sync I/O Wait Time Accumulated I/O elapsed wait time for I/O that is done under the associated thread during execution of the package. (Field name: QPACAWTI).

TCP/IP LOB XML Accumulated wait time for TCP/IP LOB or XML materialization during execution of the package. (Field name: QPACALBW).

TCP/IP LOB XML events Number of wait trace events processed for waits for TCP/IP LOB or XML materialization during execution of the package. (Field name: QPACALBC).

Threads rolled up Number of threads that roll data into this QPAC data section. QPAC records that are not rolled up have a value of 1. QPAC records that are rolled up have a value of 1 or greater. (Field name: QPACRLNU).

Total CPU Time Total CPU time for all executions of the package. This time does not include CPU time that is consumed on an IBM specialty engine. (Field name: QPACTJST).

Total Wait Events Total suspensions events. (Field name: ADTSUSCP).

Total Wait Time Total suspensions time. (Field name: ADTSUSTP).

User Defined Functions Number of user-defined functions scheduled. (Field name: QPACUDNU).

Waiting Time Waiting time. (Field name: ADWTCL7T).