IFCID 003 - Instrumentation Accounting Data Overflow

This topic shows detailed information about "Record Trace - IFCID 003 - Instrumentation Accounting Data Overflow".

                                    INSTRUMENTATION ACCOUNTING DATA OVERFLOW                           
                                                                                                       
ARCH.LOG(QUIES) SUSP TIME                  0.000000   ARCH.LOG(QUIES) SUSP EVENTS                     0
ACCUM. READ SUSP TIME                      0.000000   WAIT TRACE READ EVENTS                          0
DRAIN LOCK SUSP TIME                       0.000000   DRAIN LOCK SUSP EVENTS                          0
CLAIM RELEASE SUSP TIME                    0.000000   CLAIM RELEASE SUSP EVENTS                       0
I/O SERVICE TASK SUSP TIME                 0.000000   I/O SERVICE TASK SUSP EVENTS                    0
SYSLGRNG SUSP TIME                         0.000000   SYSLGRNG SUSP EVENTS                            0
DS MANAGER SUSP TIME                       0.000000   DS MANAGER SUSP EVENTS                          0
OTHER SERVICE SUSP TIME                    0.001353   OTHER SERVICE SUSP EVENTS                       6
COMMIT PH1 WRITE I/O TIME                  0.000000   COMMIT PH1 WRITE I/O EVENTS                     0
ASYNCH. IXL REQ. TIME                      0.000000   ASYNCH. IXL EVENTS                              0
LOB COMPRESSION SUSP TIME                  0.000000   LOB COMPRESSION SUSP EVENTS                     0
FAST INSERT PIPE WAIT TIME                 0.000000   FAST INSERT PIPE WAIT EVENTS                    0

ARCH.LOG(QUIES) SUSP TIME

The accumulated waiting time due to the processing of ARCHIVE LOG MODE(QUIESCE) commands.

This time does not represent the time required to perform the entire command.

Field Name: QWAXALOG

This is an exception field.

ARCH.LOG(QUIES) SUSP EVENTS

The number of ARCHIVE LOG MODE (QUIESCE) commands issued.

Field Name: QWAXALCT

ACCUM. READ SUSP TIME

The accumulated wait time for:

• Archive Log reads
• Active Log reads
• Active Log prefetch reads
• Fast Log apply log reads

Field Name: QWAXAWAR

WAIT TRACE READ EVENTS

DB2 V8: The number of wait trace events processed for archive reads, active reads, and active log prefetch reads.

Field Name: QWAXANAR

DRAIN LOCK SUSP TIME

The accumulated waiting time for a drain lock. This is the time the requester is suspended while waiting to acquire the drain lock.

Field Name: QWAXAWDR

This is an exception field.

DRAIN LOCK SUSP EVENTS

The number of wait trace events processed for waits for drain locks.

Field Name: QWAXARND

CLAIM RELEASE SUSP TIME

The accumulated waiting time for a drain waiting for claims to be released. After the drain lock is acquired, the drainer must wait for claim holders to release the object.

Field Name: QWAXAWCL

This is an exception field.

CLAIM RELEASE SUSP EVENTS

The number of wait trace events processed for waits for claims to be released.

Field Name: QWAXARNC

I/O SERVICE TASK SUSP TIME

Accumulated waiting time for a synchronous execution unit switch to the DB2 OPEN/CLOSE data set service for the HSM recall service.

This value is an average.

Field Name: QWAXOCSE

I/O SERVICE TASK SUSP EVENTS

Number of wait trace events processed of waits for synchronous execution unit switching to the Open/Close service.

Field Name: QWAXOCNS

SYSLGRNG SUSP TIME

Accumulated wait time for a synchronous execution unit switch to the DB2 SYSLGRNG recording service. This service is sometimes used for Level ID checking for downlevel detection.

This value is an average.

Field Name: QWAXSLSE

SYSLGRNG SUSP EVENTS

Number of wait trace events for a synchronous execution unit switch to the DB2 SYSLGRNG recording service.

Field Name: QWAXSLNS

DS MANAGER SUSP TIME

Accumulated wait time for a synchronous execution unit switch to the DB2 data space manager services. This includes DEFINE DATA SET, EXTEND DATA SET, DELETE DATA SET, RESET DATA SET, and VSAM CATALOG ACCESS.

This value is an average.

Field Name: QWAXDSSE

DS MANAGER SUSP EVENTS

Number of wait trace events for waits for synchronous execution unit switching to the DB2 data space manager services.

Field Name: QWAXDSNS

OTHER SERVICE SUSP TIME

Could be due to a VSAM catalog update. In the distributed environment, it includes the waiting time for the response from the server system. Performance trace for IFCID 46 to 50, 170, and 171 provide more detailed information for analysis.

Field Name: QWAXOTSE

OTHER SERVICE SUSP EVENTS

Number of wait trace events for a synchronous execution unit switch to other DB2 service tasks.

Field Name: QWAXOTNS

COMMIT PH1 WRITE I/O TIME

The accumulated time waiting for phase 1 commit write I/O. An example for this suspension is LOB Table Space with LOG NO Phase 1 commit database synchronous write I/O processing.

Field Name: QWAXAWFC

COMMIT PH1 WRITE I/O EVENTS

The total number of wait trace events for commit phase 1 I/O.

Field Name: ADFCSUSC

ASYNC. IXL REQ. TIME

The accumulated wait time for IXLCACHE and IXLFCOMP requests.

Field Name: QWAXIXLT

ASYNC. IXL EVENTS

Number of wait trace events processed for asynchronous IXLCACHE or IXLFCOMP invocations.

Field Name: QWAXIXLE

LOB COMPRESSION SUSP TIME

The accumulated time waiting for a compression of DB2 large objects (LOB) (DB2 field QWAX_LOBCOMP_WAIT).

Field Name: QWAX_LOBCOMP_WAIT

LOB COMPRESSION SUSP EVENTS

The number of wait trace events processed for DB2 large object (LOB) compressions.

Field Name: QWAX_LOBCOMP_COUNT

FAST INSERT PIPE WAIT TIME

The accumulated wait time for pipe wait (DB2 field QWAX_PIPE_WAIT).

Field Name: QWAX_PIPE_WAIT

FAST INSERT PIPE WAIT EVENTS

The number of wait trace events that were processed for pipe wait (DB2 field QWAX_PIPEWAIT_COUNT).

Field Name: QWAX_PIPEWAIT_COUNT