DETECTEDDEADLOCKS

DEADLOCKNUMBER

FIXED(20)

Number of detected and documented deadlocks

DEADLOCKTIME

TIMESTAMP

Detection time of deadlock

TABLENAME

CHAR(32)

Name of the table

TABLEID

CHAR(8) BYTE

Identification of the table

PARTITIONID

FIXED(5)

Identification of the partition

HOLDERTASKID

FIXED(10)

Identification of user task that holds the lock

HOLDERAPPLICATIONID

FIXED(10)

Identification of process on the client hardware that holds the lock

HOLDERAPPLICATIONNODE

CHAR(64)

Identification of client hardware on which the application process runs that holds the lock

HOLDERKEY

CHAR(128)

Prefix of the key of the locked row

HOLDERKEYHEX

CHAR(64) BYTE

Prefix of the key of the locked row in hexadecimal notation

HOLDERLOCKMODE

CHAR(26)

Type of lock held

REQUESTORTASKID

FIXED(10)

Identification of user task that requests the lock

REQUESTORAPPLICATIONID

FIXED(10)

Identification of process on the client hardware that requests the lock

REQUESTORAPPLICATIONNODE

CHAR(64)

Identification of client hardware on which the application process runs that requests the lock

REQUESTORKEY

CHAR(128)

Prefix of key of requested row

REQUESTERKEYHEX

CHAR(64) BYTE

Prefix of key of requested row in hexadecimal format

REQUESTORLOCKMODE

CHAR(26)

Type of lock request

REQUESTORROLLEDBACK

CHAR(3)

Victim of detected deadlock, transaction rolled back (error code: -60 or 600)

REQUESTORSTATEMENT

VARCHAR(4000)

Current SQL statement requesting the lock

REQUESTORAPPLICATIONINFORMATION

VARCHAR(120)

Optional information on requester application

REQUESTORAPPLICATIONLINENUMBER

FIXED(10)

Optional information on code line in requestor application