DB2LODLK - RFC - Deadlock Table
RFC - Deadlock Table information is stored in SAP table DB2LODLK.
It is part of development package STU3 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "Development Class for Database Monitor".
It is part of development package STU3 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "Development Class for Database Monitor".
Fields for table DB2LODLK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| LODLKSSID | DB2 subsystem ID | X | DB2SWPSSID | CHAR | 4 | |
| LODLKLUUV | Instance number (unique value) | X | DB2INSTNO | RAW | 12 | |
| LODLKDATE | Field of type DATS | X | DATS | DATS | 8 | |
| LODLKTIME | Field of type TIMS | X | TIMS | TIMS | 6 | |
| LODLKMSEC | Event time stamp (milliseconds) | X | DB2EVTTMS | CHAR | 6 | |
| LODLKPLAN | DB2 plan name | DB2WHCPLAN | CHAR | 128 | ||
| LODLKCN | The connection ID of the thread | DB2WHCCN | CHAR | 8 | ||
| LODLKCV | The correlation ID of the thread (IP address) | DB2WHCCV | CHAR | 16 | ||
| LODLKAID | The authorization ID under which the transaction is running | DB2WHCAID | CHAR | 128 | ||
| LODLKEUID | DB2: End user ID (in DB2 sense) | DB2LEUID | CHAR | 128 | ||
| LODLKEUTX | End user transaction name | DB2LEUTX | CHAR | 32 | ||
| LODLKEUWN | End user workstation name | DB2LEUWN | CHAR | 18 | ||
| LODLKDSGN | DB2/390: Data sharing group | DB2DSGN | CHAR | 8 | ||
| LODLKMEMN | DB2 member name in data sharing environment | DB2MEMN | CHAR | 8 | ||
| LODLKIT | DB2/390: Deadlock interval counter | DB2W0172IT | NUMC | 10 | ||
| LODLKNR | Number of resources | DB2W0172NR | NUMC | 10 |