Package Times - Class 8 - Suspensions

This topic shows detailed information about Accounting - Package Times - Class 8 - Suspensions.

This block provides suspension information for class 8.

The following example shows both layouts, the report on the left, and the trace layout on the right.

Accounting - Package Times - Class 8 - Suspensions

The field labels shown in the following sample layout of Accounting - Package Times - Class 8 - Suspensions are described in the following section. 


Report:                                                     Trace:

PACKAGE             AVERAGE TIME  AVG.EV    TIME/EVENT      PACKAGE                     TIME  EVENTS    TIME/EVENT
------------------  ------------  ------  ------------      ------------------  ------------  ------  ------------
LOCK/LATCH              0.000000    0.00           N/C      LOCK/LATCH              0.000000       0           N/C
 IRLM LOCK+LATCH        0.000000    0.00           N/C       IRLM LOCK+LATCH        0.000000       0           N/C
 DB2 LATCH              0.000000    0.00           N/C       DB2 LATCH              0.000000       0           N/C
SYNCHRONOUS I/O         0.000000    0.00           N/C      SYNCHRONOUS I/O         0.000000       0           N/C
OTHER READ I/O          0.000000    0.00           N/C      OTHER READ I/O          0.000000       0           N/C
OTHER WRITE I/O         0.000000    0.00           N/C      OTHER WRITE I/O         0.000000       0           N/C
SERV.TASK SWITCH        0.000000    0.00           N/C      SERV.TASK SWITCH        0.000000       0           N/C
ARCH.LOG(QUIESCE)       0.000000    0.00           N/C      ARCH.LOG(QUIESCE)       0.000000       0           N/C
ARCHIVE LOG READ        0.000000    0.00           N/C      ARCHIVE LOG READ        0.000000       0           N/C
DRAIN LOCK              0.000000    0.00           N/C      DRAIN LOCK              0.000000       0           N/C
CLAIM RELEASE           0.000000    0.00           N/C      CLAIM RELEASE           0.000000       0           N/C
PAGE LATCH              0.000000    0.00           N/C      PAGE LATCH              0.000000       0           N/C
NOTIFY MESSAGES         0.000000    0.00           N/C      NOTIFY MESSAGES         0.000000       0           N/C
GLOBAL CONTENTION       0.000000    0.00           N/C      GLOBAL CONTENTION       0.000000       0           N/C
TCP/IP LOB XML          0.000000    0.00           N/C      TCP/IP LOB XML          0.000000       0           N/C
ACCELERATOR             0.000000    0.00           N/C      ACCELERATOR             0.000000       0           N/C
PQ SYNCHRONIZATION      0.000000    0.00           N/C      PQ SYNCHRONIZATION      0.000000       0           N/C
FAST INSERT PIPE        0.000000    0.00           N/C      FAST INSERT PIPE        0.000111       1           N/C    
TOTAL CL8 SUSPENS.      0.000000    0.00           N/C      TOTAL CL8 SUSPENS.      0.000000       0           N/C
PACKAGE

This label is replaced by the package name, or, if ORDER (ACTNAME) was in effect, the package activity name. An activity name is truncated if it is longer than 8 characters.

Field Name: PACKAGE

AVERAGE TIME - LOCK/LATCH

The sum of the number of wait trace events processed for waits for lock and the number of wait trace events processed for page latch contention while executing this package.

Note: The internally defined field adjusts the original DB2® value. DB2 counts each event twice, one for the entry and one for the exit.

Field Name: AWTPLOLA

AVERAGE TIME - IRLM LOCK+LATCH

The accumulated lock elapsed wait time that occurred while executing this package.

Background and Tuning Information

OMEGAMON XE for DB2 PE might adjust this value if the thread was suspended when performance data was gathered.

If the suspension time is high, investigate locking activity.

Field Name: QPACAWTL

This is an exception field.

AVERAGE TIME - DB2 LATCH

The accumulated latch elapsed wait time for latch suspensions that occurred while executing this package.

Field Name: QPACAWLH

AVERAGE TIME - SYNCHRONOUS I/O

The accumulated elapsed wait time for I/O suspensions under this thread during the execution of the package or DBRM.

Background and Tuning Information

OMEGAMON XE for DB2 PE might adjust this value if the thread was suspended when its performance data was gathered.

Field Name: QPACAWTI

This is an exception field.

AVERAGE TIME - OTHER READ I/O

The accumulated waiting time for a read I/O performed under a thread other than this one during the execution of the package or DBRM.

Background and Tuning Information

OMEGAMON XE for DB2 PE might adjust this value if the thread was suspended when performance data was gathered.

This field includes waits caused by sequential prefetch, list prefetch, dynamic prefetch, and synchronous read I/O performed by other threads.

If the value in this field is high, the problem could be an I/O bound query using prefetch or an I/O contention. The application is accessing data from a busy data set, volume, or control unit and is continually being suspended. Consult the DBA and MVS systems programmer.

Field Name: QPACAWTR

This is an exception field.

AVERAGE TIME - OTHER WRITE I/O

The accumulated waiting time due to a write I/O performed for another thread during the execution of a package or DBRM.

Background and Tuning Information

If the value in this field is high, the problem could be I/O contention. The application is accessing data from a busy data set, volume, or control unit and is continually being suspended. Consult the DBA and MVS systems programmer to resolve possible data set placement problems.

Field Name: QPACAWTW

This is an exception field.

AVERAGE TIME - SERV.TASK SWITCH

The accumulated waiting time due to a synchronous execution unit switch to DB2 services from this thread during the execution of the package or DBRM.

Background and Tuning Information

OMEGAMON XE for DB2 PE might adjust this value if the thread was suspended when its performance data was gathered.

This value includes the waits because of an OPEN/CLOSE data set, SYSLGRNG update, DATASPACE MANAGER services, DEFINE, EXTEND, and DELETE data set, AUTONOMOUS PROCEDURE, and DDF Requester waiting for Server reply and VSAM Catalog update.

Field Name: QPACAWTE

This is an exception field.

AVERAGE TIME - ARCH.LOG(QUIESCE)

The accumulated waiting time caused by processing ARCHIVE LOG(QUIESCE) commands during the execution of the package or DBRM. This number represents the amount of time that an individual thread was suspended because of the command, not the time it took for the entire command to complete.

Background and Tuning Information

OMEGAMON XE for DB2 PE might adjust this value if the thread was suspended when its performance data was gathered.

Avoid issuing the -ARCHIVE LOG QUIESCE command during peak periods.

Field Name: QPACALOG

AVERAGE TIME - DRAIN LOCK

The accumulated waiting time due to a drain lock.

Field Name: QPACAWDR

AVERAGE TIME - CLAIM RELEASE

The accumulated waiting time for a drain waiting for claims to be released during the execution of the package or DBRM.

Background and Tuning Information

OMEGAMON XE for DB2 PE might adjust this value if the thread was suspended when its performance data was gathered.

Field Name: QPACAWCL

AVERAGE TIME - PAGE LATCH

The accumulated waiting time caused by a page latch contention.

Field Name: QPACAWTP

AVERAGE TIME - NOTIFY MESSAGES

The accumulated elapsed waiting time due to suspensions caused by sending notify messages to other members in the data sharing group. Messages are sent, for example, when database descriptors are changed due to DDL.

This value is only calculated if accounting class 8 is active and DB2 is a member of a DB2 data sharing group.

Field Name: QPACAWTG

AVERAGE TIME - GLOBAL CONTENTION

The accumulated waiting time caused by the suspension of IRLM lock requests due to global lock contentions in a data sharing environment that require intersystem communication to resolve.

Field Name: APGCSUST

AVERAGE TIME - TCP/IP LOB XML

The accumulated wait time for TCP/IP LOB and XML materialization while running this package or DBRM.

Field Name: QPACALBW

AVERAGE TIME - ACCELERATOR

The accumulated wait time for requests to an accelerator while executing this package.

Field Name: QPACAACW

AVERAGE TIME - PQ SYNCHRONIZATION

The accumulated time waiting for parallel query processing to synchronize between parent and child tasks.

Field Name: APPQSST

AVERAGE TIME - FAST INSERT PIPE

The accumulated wait time for a pipe while this package was executed (DB2 field QPAC_PIPE_WAIT).

Field Name: APPISUST

AVERAGE TIME - TOTAL CL8 SUSPENS.

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

Field Name: ADTSUSTP

This is an exception field.

AVG.EV - LOCK/LATCH

The sum of the number of wait trace events processed for waits for local contention for locks and the number of wait trace events processed for waits for latch contention while executing this package.

Note: The internally defined field adjusts the original DB2 value. DB2 counts each event twice, one for the entry and one for the exit.

Field Name: ADLLPSSC

This is an exception field.

AVG.EV - IRLM LOCK+LATCH

The number of wait trace events processed for waits for lock while executing this package.

Note: The internally defined field adjusts the original DB2 value. DB2 counts each event twice, one for the entry and one for the exit.

Field Name: ADLBPSSC

AVG.EV - DB2 LATCH

The number of wait trace events processed for page latch contention while executing this package.

Note: The internally defined field adjusts the original DB2 value. DB2 counts each event twice, one for the entry and one for the exit.

Field Name: ADLAPSSC

AVG.EV - SYNCHRONOUS I/O

The total number of synchronous I/O suspensions under this thread during the execution of the package or DBRM.

Field Name: ADIOPSSC

AVG.EV - OTHER READ I/O

The total number of suspensions due to a read I/O performed under a thread other than the one being reported.

Field Name: ADARPSSC

AVG.EV - OTHER WRITE I/O

The total number of suspensions due to a write I/O performed under a thread other than this one during the execution of a package or DBRM.

Field Name: ADAWPSSC

AVG.EV - SERV.TASK SWITCH

The total number of suspensions due to a synchronous execution unit switch to DB2 services during the execution of the package or DBRM.

Field Name: ADSTPSSC

AVG.EV - ARCH.LOG(QUIESCE)

The total number of suspensions caused by processing ARCHIVE LOG(QUIESCE) commands during the execution of the package or DBRM.

Field Name: ADALPSSC

AVG.EV - ARCHIVE LOG READ

The number of wait trace events processed for archive reads, active reads, and active log prefetch reads while running this package or DBRM.

Field Name: ADLRPSSC

AVG.EV - DRAIN LOCK

The total number of suspensions due to drain lock processing during the execution of the package or DBRM.

Field Name: ADDRPSSC

AVG.EV - CLAIM RELEASE

The total number of suspensions until the claims are released during the execution of the package or DBRM.

Field Name: ADCMPSSC

AVG.EV - PAGE LATCH

The total number of suspensions due to page latch contentions during the execution of the package or DBRM.

Field Name: ADPGPSSC

AVG.EV - NOTIFY MESSAGES

The number of suspensions due to messages being sent to other members in the data sharing group. This value is calculated only if accounting class 8 is active and DB2 is a member of a data sharing group.

Field Name: ADNOPSSC

AVG.EV - GLOBAL CONTENTION

The total number of suspensions during global lock contention. This value is calculated only if accounting class 8 is active and DB2 is a member of a data sharing group.

Field Name: ADGCPSSC

AVG.EV - TCP/IP LOB XML

The number of wait trace events processed for waits for TCP/IP LOB and XML materialization while running this package or DBRM.

Field Name: ADLMPSSC

AVG.EV - ACCELERATOR

The total number of suspensions due to a request to an accelerator during the execution of the package.

Field Name: ADAAPSSC

AVG.EV - PQ SYNCHRONIZATION

The number of times the parallel query processing suspended because it was waiting for the synchronization of the parent/child.

Field Name: APPQSSC

AVG.EV - FAST INSERT PIPE

The number of wait trace events that were processed for waits for a pipe while this package was executed (DB2 field QPAC_PIPEWAIT_COUNT / 2).

Field Name: APPISUSC

AVG.EV - TOTAL CL8 SUSPENS.

The number of all types of class 8 suspensions.

Field Name: ADTSUSCP

This is an exception field.

TIME/EVENT - LOCK/LATCH

The sum of the number of wait trace events processed for waits for local contention for locks and the number of wait trace events processed for waits for latch contention while executing this package.

Note: The internally defined field adjusts the original DB2 value. DB2 counts each event twice, one for the entry and one for the exit.

Field Name: AALLPTMC

TIME/EVENT - IRLM LOCK+LATCH

The number of wait trace events processed for waits for lock while executing this package.

Note: The internally defined field adjusts the original DB2 value. DB2 counts each event twice, one for the entry and one for the exit.

Field Name: AALOPTMC

TIME/EVENT - DB2 LATCH

The number of wait trace events processed for page latch contention while executing this package.

Note: The internally defined field adjusts the original DB2 value. DB2 counts each event twice, one for the entry and one for the exit.

Field Name: AALAPTMC

TIME/EVENT - SYNCHRONOUS I/O

The synchronous I/O suspension time per event.

Field Name: AAIOPTMC

TIME/EVENT - OTHER READ I/O

Any other read time per event.

Field Name: AAARPTMC

TIME/EVENT - OTHER WRITE I/O

Any other write time per event.

Field Name: AAAWPTMC

TIME/EVENT - SERV.TASK SWITCH

The synchronous execution service time per event.

Field Name: AASTPTMC

TIME/EVENT - ARCH.LOG(QUIESCE)

The archive log time per event.

Field Name: AAALPTMC

TIME/EVENT - ARCHIVE LOG READ

The archive read suspension time per event.

Field Name: AALRPTMC

TIME/EVENT - DRAIN LOCK

The drain lock time per event.

Field Name: AADRPTMC

TIME/EVENT - CLAIM RELEASE

The claim release time per event.

Field Name: AACMPTMC

TIME/EVENT - PAGE LATCH

The page latch time per event.

Field Name: AAPGPTMC

TIME/EVENT - NOTIFY MESSAGES

The notify messages time per event.

Field Name: AANOPTMC

TIME/EVENT - GLOBAL CONTENTION

The global contention time per event.

Field Name: AAGCPTMC

TIME/EVENT - TCP/IP LOB XML

The accumulated wait time for TCP/IP LOB and XML materialization while running this package or DBRM.

Field Name: QPACALBW

TIME/EVENT - ACCELERATOR

The accelerator waiting time per event during the execution of the package

Field Name: AAAAPTMC

TIME/EVENT - PQ SYNCHRONIZATION

The average wait time for a package for parallel query processing to synchronize between parent and child tasks.

Field Name: APPQSTMC

TIME/EVENT - FAST INSERT PIPE

The average wait time for a pipe.

Field Name: APPITMCN

TIME/EVENT - TOTAL CL8 SUSPENS.

The class 8 time per event.

Field Name: AATOTSTP