DB2LODRS - RFC - Deadlock Resources
RFC - Deadlock Resources information is stored in SAP table DB2LODRS.
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 DB2LODRS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| LODRSSSID | DB2 subsystem ID | X | DB2SWPSSID | CHAR | 4 | |
| LODRSLUUV | Instance number (unique value) | X | DB2INSTNO | RAW | 12 | |
| LODRSDATE | Field of type DATS | X | DATS | DATS | 8 | |
| LODRSTIME | Field of type TIMS | X | TIMS | TIMS | 6 | |
| LODRSMSEC | Event time stamp (milliseconds) | X | DB2EVTTMS | CHAR | 6 | |
| LODRSCNT | DB2/390: Unique counter | X | DB2UCNT | INT4 | 4 | |
| LODRSFR | The type of resource held by a lock | DB2RESTYPE | CHAR | 20 | ||
| LODRSKD | The name of the DB2 database | DB2DBOWNER | CHAR | 16 | ||
| LODRSKP | Object name | DB2PAGES2 | CHAR | 18 | ||
| LODRSK1 | Page number | DB2PAGENR | CHAR | 10 | ||
| LODRSK2 | Row ID or partition number, depending on resource type | DB2PARTNR | CHAR | 3 | ||
| LODRSHP | DB2 plan name | DB2WHCPLAN | CHAR | 128 | ||
| LODRSHB | The authorization ID under which the transaction is running | DB2WHCAID | CHAR | 128 | ||
| LODRSHN | The connection ID of the thread | DB2WHCCN | CHAR | 8 | ||
| LODRSHR | The correlation ID of the thread (IP address) | DB2WHCCV | CHAR | 16 | ||
| LODRSHC | DB2: End user ID (in DB2 sense) | DB2LEUID | CHAR | 128 | ||
| LODRSHJ | End user transaction name | DB2LEUTX | CHAR | 32 | ||
| LODRSHK | End user workstation name | DB2LEUWN | CHAR | 18 | ||
| LODRSHLUUV | Instance number (unique value) | DB2INSTNO | RAW | 12 | ||
| LODRSHT | DB2/390: Unique counter | DB2UCNT | INT4 | 4 | ||
| LODRSHI | DB2 member name in data sharing environment | DB2MEMN | CHAR | 8 | ||
| LODRSHS | The mode of the lock held on the resource | DB2LOCKMS | CHAR | 3 | ||
| LODRSHD | Lock duration of the thread holding the resource | DB2SWD | CHAR | 12 | ||
| LODRSHF | RFC - raw 1 | DB2RAW1 | RAW | 1 | ||
| LODRSWP | DB2 plan name | DB2WHCPLAN | CHAR | 128 | ||
| LODRSWB | The authorization ID under which the transaction is running | DB2WHCAID | CHAR | 128 | ||
| LODRSWN | The connection ID of the thread | DB2WHCCN | CHAR | 8 | ||
| LODRSWR | The correlation ID of the thread (IP address) | DB2WHCCV | CHAR | 16 | ||
| LODRSWC | DB2: End user ID (in DB2 sense) | DB2LEUID | CHAR | 128 | ||
| LODRSWJ | End user transaction name | DB2LEUTX | CHAR | 32 | ||
| LODRSWK | End user workstation name | DB2LEUWN | CHAR | 18 | ||
| LODRSWLUUV | Instance number (unique value) | DB2INSTNO | RAW | 12 | ||
| LODRSWT | DB2/390: Unique counter | DB2UCNT | INT4 | 4 | ||
| LODRSWI | DB2 member name in data sharing environment | DB2MEMN | CHAR | 8 | ||
| LODRSWF | IRLM function request (LOCK, UNLOCK, or CHANGE) | DB2SWU | CHAR | 6 | ||
| LODRSWS | The mode of the lock held on the resource | DB2LOCKMS | CHAR | 3 | ||
| LODRSWD | DB2/390: Waiter duration | DB20172WD | CHAR | 12 | ||
| LODRSWG | RFC - raw 1 | DB2RAW1 | RAW | 1 | ||
| LODRSWA | Timeout intervals that can occur before agent is timed out | DB2W0196CC | NUMC | 5 |