DB2LOTHW - RFC - Timeout Waiter and Holder
RFC - Timeout Waiter and Holder information is stored in SAP table DB2LOTHW.
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 DB2LOTHW
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
LOTHWSSID | DB2 subsystem ID | X | DB2SWPSSID | CHAR | 4 | |
LOTHWLUUV | Instance number (unique value) | X | DB2INSTNO | RAW | 12 | |
LOTHWDATE | Field of type DATS | X | DATS | DATS | 8 | |
LOTHWTIME | Field of type TIMS | X | TIMS | TIMS | 6 | |
LOTHWMSEC | Event time stamp (milliseconds) | X | DB2EVTTMS | CHAR | 6 | |
LOTHWCNT | DB2/390: Unique counter | X | DB2UCNT | INT4 | 4 | |
LOTHWHW | H=Holder, W = Waiter, and R = Retained | DB2W0196HW | CHAR | 1 | ||
LOTHWHP | DB2 plan name | DB2WHCPLAN | CHAR | 128 | ||
LOTHWHB | The authorization ID under which the transaction is running | DB2WHCAID | CHAR | 128 | ||
LOTHWHN | The connection ID of the thread | DB2WHCCN | CHAR | 8 | ||
LOTHWHR | The correlation ID of the thread (IP address) | DB2WHCCV | CHAR | 16 | ||
LOTHWHC | DB2: End user ID (in DB2 sense) | DB2LEUID | CHAR | 128 | ||
LOTHWHJ | End user transaction name | DB2LEUTX | CHAR | 32 | ||
LOTHWHK | End user workstation name | DB2LEUWN | CHAR | 18 | ||
LOTHWHLUUV | Field type char, length 12 | DB2CHAR12 | CHAR | 12 | ||
LOTHWHT | Holder token | DBW0196HT | INT4 | 4 | ||
LOTHWHI | DB2 member name in data sharing environment | DB2MEMN | CHAR | 8 | ||
LOTHWHS | The mode of the lock held on the resource | DB2LOCKMS | CHAR | 3 | ||
LOTHWHD | Lock duration of the thread holding the resource | DB2SWD | CHAR | 12 | ||
LOTHWHF | RFC - raw 1 | DB2RAW1 | RAW | 1 |