Deadlock Header attributes

Use these attributes to view deadlock header information.

Connection Name The connection name of the thread waiting for the resource. Connection name: Not valid on end of memory and reflects the z/OS home ASID connection name. (Field name: QW0172WN).

For batch: 'BATCH'
For TSO: 'TSO'
For QMF: 'DB2CALL'
For UTILITY: 'UTILITY'
For DB2 INTERNAL: DB2 SUBSYSTEM ID
For IMS: IMS-ID
For CICS: CICS-ID
For RRSAF: 'RRSAF'

For distributed database access threads:

For threads from a DB2 requester, this field contains the connection name of the thread at the requesting location.
For threads using the DRDA protocol from a non-DB2 requester, this field contains the constant 'SERVER'.

Correlation ID The correlation ID of the thread waiting for the resource (Field name: QW0172WR). Correlation ID value:

For batch: JOBNAME
For TSO: LOGON-ID
For IMS/VS: PST#.PSBNAME
For CICS: CONNECTION_TYPE.THREAD_TYPE.THREAD_#.TRAN-ID
For RRSAF: CORRELATION-ID value from signon function
For threads from a DB2 requester, this field contains the CORRELATION-ID name of the thread at the requesting location.
For threads using the DRDA protocol from a non-DB2 requester, this field contains the first 12 characters in the DDM external name (EXTNAM) parameter of the DDM EXCSAT command received as part of the SQL connect.

Data Sharing Group The Data Sharing Group Name (Field name: GROUP).

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

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

DSG Member Name The Data Sharing Group Member Name (Field name: MEMBER).

End User The end user user ID of the thread waiting for the resource. This field contains blanks if the client did not supply this information, or if the information is too long to fit in this field. (Field name: QW0172WC).

Event Date Time of Event (Field name: DATEATIM).

Event Stck Event timestamp (Field name: DATESTCK).

Group Name DB2 data sharing group name (Field name: QWHADSGN).

Instance Number Instance number. Displayed as 12 hex characters. When concatenated with the fully qualified network name, it uniquely identifies a distributed thread. (Though this field may appear to be a timestamp, it is not to be processed as one.) For more information see the -DISPLAY THREAD command in Command Reference. (Field name: QWHSLUUV).

Interval Counter Deadlock interval counter (Field name: QW0172IT).

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

Member Name DB2 member name within the DB2 data sharing group (Field name: QWHAMEMN).

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

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).

Plan Name The plan name (Field name: QWHCPLAN). It shows blank for Db2 command thread; otherwise:

For SPUFI with cursor stability: 'DSNESPCS'
For SPUFI with repeatable read: 'DSNESPRR'
For TSO: the application plan name
For IMS: the application plan name
For CICS: application plan name, IMS and CICS commands have a blank plan name.
For RRSAF create thread with the collection parameter: '?RRSAF '
For QMF: 'DSQPLAN'
For Distributed Database Access threads:
- For threads using the DRDA protocol from a requester, this field contains the plan name that is executed at the requesting location.
- For threads using the DRDA protocol from a non-DB2 requester or from a DB2 2.3 requester, this field contains the constant 'DISTSERV'.
For binding: 'DSNBIND' (system plan)
For utility: 'DSNUTIL ' (system plan)
For authorization: 'ACT' + X'0000000000' (system plan)
For unallocated threads and miscellaneous Db2 system service tasks: 'BCT' + X'0000000000' (system plan)
For startup: 'STARTCT' + X'00' (system plan)

Primary AuthID The authorization ID of the thread waiting for the resource (Field name: QW0172WB).

For TSO: LOGON-ID
For batch: USER-ID on job statement
For RRSAF:
If the following conditions are true, RRSAF uses the value in ACEEUSRI as the initial primary authorization ID:
- The system authorization facility (SAF) and a security product, such as RACF, is used.
- There is an ACEE associated with the job step TCB or with the AXSB.
- The first 7 characters of the job step user ID match the first 7 characters of the value in ACEEUSRI.
If any of the above conditions are not true, then the initial primary authorization ID is the value in ASXBUSER.
For IMS (message-driven regions): SIGNON-ID, LTERM, ASXBUSR, or PSB name.
For IMS (control regions): USER-ID on job statement, or RACF, started procedure entry if RACF is used.
For CICS: USERID, OPID, GROUP, SIGN, or TERM, or TX, as specified in the DB2ENTRY resource definition.
For z/OS OPERATOR commands and DB2 system internal agents: = 'SYSOPR'.
For a distributed application server (AS):
- If the application requester (AR) is a DB2 system, this is the same value that was assigned at the AR.
- If the application requester is not a DB2 system, this is the user ID that was used to make the initial connection with the application server.

The user ID is obtained in one of the following ways:

Passed by the requester in the allocate conversation flow (FMH5)
Passed by the requester in the DRDA security flow
Derived by the server from the RACF passticket
Provided by the requester in the DRDA security flow

Resources Involved Number of unsatisfied requests that are waiting for locks on resources (field name: QW0172NR).

STCK Deadlock Detected (Field name: DFRMSTCK).

Subystem IDSubystem ID The MVS system ID (SID). (Field name: QWHSSID).

Time Deadlock Detected The time (STCK) that the deadlock was detected (Field name: DATIFROM).

Transaction Name The transaction name of the thread waiting for the resource. This field contains blanks if the client did not supply this information, or if the information is too long to fit in this field. (Field name: QW0172WJ).

Workstation Name The workstation name of the thread waiting for the resource. This field contains blanks if the client did not supply this information, or if the information is too long to fit in this field. (Field name: QW0172WK).