IFCID 172 - Unit of Work - Waiter

This topic shows detailed information about Record Trace - IFCID 172 - Unit of Work - Waiter.

Record Trace - IFCID 172 - Unit of Work - Waiter

The field labels shown in the following sample layout of Record Trace - IFCID 172 - Unit of Work - Waiter are described in the following section. 


W A I T E R
PRIMAUTH    : 'BLANK'    PLAN NAME : WAITPLAN     CORR ID : WAITCORRID01          CONN ID : WAITCONN
NETWORKID   : LUWID 1    LUNAME    : XXXXXXXX     OWNING WORK UNIT:      51683    UNIQUENESS VALUE: X'E7E7E7E7E7E7'
MEMBER      : WAITMEM2   DURATION  :   PLAN       STATE   : SHARED                ACE  :   3
TRANSACTION : WAITER TRANSACTION NAME             WS_NAME : WAITER WORKSTATION    END_USER: 'BLANK'
PROGRAM NAME: PGM000W1   LOCATION  : LOCATION000000W1                             PCKG/COLL ID: COLLECTIONID0000W1
CONS TOKEN  : X'C1C2C3C4C5C6C7C8'                 STMT ID : X'1234567890123456'   TYPE: X'0000'
Db2S ASIC   :    59073   REQ WORK UNIT:  51683    EB PTR : X'E6E4D9F1'            REQ FUNCTION: CHANGE
WORTH       : X'12'      WORTH SOURCE :  OTHER    QW0172WG: X'30'
PRIMAUTH

The authorization ID of the thread waiting for the resource.

Field Name: QW0172WB

PLAN NAME

The plan name of the waiter.

Field Name: QW0172WP

CORR ID

The correlation ID of the waiter.

Field Name: QW0172WR

CONN ID

The connection ID of the waiter.

Field Name: QW0172WN

NETWORKID
Provides the following information:
  • The logical unit of work identifier of the waiter. The data shown is only valid for distributed threads.
  • The logical unit name of the waiter. The data shown is only valid for distributed threads.
  • The uniqueness value of the waiter. The data shown is only valid for distributed threads.

Field Name: QW0172WL

LUNAME
Provides the following information:
  • The logical unit of work identifier of the waiter. The data shown is only valid for distributed threads.
  • The logical unit name of the waiter. The data shown is only valid for distributed threads.
  • The uniqueness value of the waiter. The data shown is only valid for distributed threads.

Field Name: QW0172WL

OWNING WORK UNIT

The owning unit of work of the waiter.

Field Name: QW0172WO

UNIQUENESS VALUE
Provides the following information:
  • The logical unit of work identifier of the waiter. The data shown is only valid for distributed threads.
  • The logical unit name of the waiter. The data shown is only valid for distributed threads.
  • The uniqueness value of the waiter. The data shown is only valid for distributed threads.

Field Name: QW0172WL

MEMBER

The waiter's Db2 member name.

Field Name: QW0172WI

DURATION
The lock duration of the thread waiting for the resource.
MANUAL
Varies depending on the ISOLATION parameter (QW0172DR=x'20')
MANUAL+1
Temporary change of consistency level from CS to RR during bind and DDL (QW0172DR=x'21')
COMMIT
Until commit (QW0172DR=x'40')
COMMIT+1
Past commit; applies to locks needed to maintain the position for a cursor opened WITH HOLD (QW0172DR=x'41')
ALLOCATION
Until deallocation (QW0172DR=x'60')
PLAN
For the duration of the plan (QW0172DR=x'80')
UTIL
For the duration of the utility execution (QW0172DR=x'81')
INTEREST
Duration used for P-locks (QW0172DR=x'FE')
FREE ALL
Until all locks are freed (QW0172DR=x'FF')
N/A
Not applicable for NOTIFY SUSPEND

Field Name: QW0172WD

STATE

The lock state of the thread waiting for the resource.

Field Name: QW0172WS

ACE

The owning unit of work of the waiter.

Field Name: QW0172WO

TRANSACTION

The transaction or application name that is run.

Field Name: QWHCEUTX

WS_NAME

The end user's workstation name.

Field Name: QWHCEUWN

END_USER

The user ID of the workstation end user. This user ID can be different from the authorization ID used to connect to Db2. This field contains blanks if the client does not supply this information.

Field Name: QWHCEUID

PROGRAM NAME

The name of the program that is contending the resource. It need not be the program that acquired the lock.

Background and Tuning Information

The name of the program that is contending the resource. It need not be the program that acquired the lock.

Field Name: QW0172Q5

LOCATION

Package collection ID of the program contending the resource. It need not be the program that acquired the lock.

Background and Tuning Information

Package collection ID of the program contending the resource. It need not be the program that acquired the lock.

Field Name: QW0172Q6

PCKG/COLL ID

Location of the program contending the resource. It need not be the program that acquired the lock.

Background and Tuning Information

Location of the program contending the resource. It need not be the program that acquired the lock.

Field Name: QW0172Q7

CONS TOKEN

Consistency token of the program contending the resource. It need not be the program that acquired the lock.

Background and Tuning Information

Consistency token of the program contending the resource. It need not be the program that acquired the lock.

Field Name: QW0172Q8

STMT ID

The waiter statement ID.

Field Name: QW0172WZ

TYPE

The waiter statement information.

Field Name: QW0172WY

Db2S ASIC

The Db2S ASIC of the waiter. A unique number allocated to the requesting work unit of the waiter. The EB pointer of the waiter.

Field Name: QW0172AS

REQ WORK UNIT

The waiter's requesting work unit.

Field Name: QW0172UW

EB PTR

The EB pointer of the waiter.

Field Name: QW0172WE

REQ FUNCTION

The function requested by the waiter.

Field Name: QW0172WF

WORTH

The worth value Db2 assigns to the waiter.

Field Name: QW0172WA

WORTH SOURCE

Source of the waiters Db2 assigned worth value. Possible values are: GLOBAL, OTHER, N/P

Field Name: QW0172WAS