DB2LOTRS - RFC - Timeout Resources
RFC - Timeout Resources information is stored in SAP table DB2LOTRS.
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 DB2LOTRS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| LOTRSSSID | DB2 subsystem ID | X | DB2SWPSSID | CHAR | 4 | |
| LOTRSLUUV | Instance number (unique value) | X | DB2INSTNO | RAW | 12 | |
| LOTRSDATE | Field of type DATS | X | DATS | DATS | 8 | |
| LOTRSTIME | Field of type TIMS | X | TIMS | TIMS | 6 | |
| LOTRSMSEC | Event time stamp (milliseconds) | X | DB2EVTTMS | CHAR | 6 | |
| LOTRSPLAN | DB2 plan name | DB2WHCPLAN | CHAR | 128 | ||
| LOTRSAID | The authorization ID under which the transaction is running | DB2WHCAID | CHAR | 128 | ||
| LOTRSCN | The connection ID of the thread | DB2WHCCN | CHAR | 8 | ||
| LOTRSCV | The correlation ID of the thread (IP address) | DB2WHCCV | CHAR | 16 | ||
| LOTRSEUID | DB2: End user ID (in DB2 sense) | DB2LEUID | CHAR | 128 | ||
| LOTRSEUTX | End user transaction name | DB2LEUTX | CHAR | 32 | ||
| LOTRSEUWN | End user workstation name | DB2LEUWN | CHAR | 18 | ||
| LOTRSDSGN | DB2/390: Data sharing group | DB2DSGN | CHAR | 8 | ||
| LOTRSMMEMN | DB2 member name in data sharing environment | DB2MEMN | CHAR | 8 | ||
| LOTRSNU | Number of holders | DB2NUMH | NUMC | 10 | ||
| LOTRSFR | The type of resource held by a lock | DB2RESTYPE | CHAR | 20 | ||
| LOTRSKD | The name of the DB2 database | DB2DBOWNER | CHAR | 16 | ||
| LOTRSKP | Object name | DB2PAGES2 | CHAR | 18 | ||
| LOTRSK1 | Page number | DB2PAGENR | CHAR | 10 | ||
| LOTRSK2 | Row ID or partition number, depending on resource type | DB2PARTNR | CHAR | 3 | ||
| LOTRSWU | IRLM function request (LOCK, UNLOCK, or CHANGE) | DB2SWU | CHAR | 6 | ||
| LOTRSWS | The mode of the lock held on the resource | DB2LOCKMS | CHAR | 3 | ||
| LOTRSWD | Lock duration of the thread holding the resource | DB2SWD | CHAR | 12 | ||
| LOTRSWF | Conditional / Unconditional | DB2RSWF | RAW | 1 | ||
| LOTRSTI | Maximum time DB2 waits for the release of a locked resource | DB2WP4TOUT | INT4 | 4 | ||
| LOTRSTC | Timeout intervals that can occur before agent is timed out | DB2W0196CC | NUMC | 5 |