The DB2LOTRS table in SAP ERP or S/4HANA stores RFC – Timeout Resources data. There are total 26 fields in DB2LOTRS table. The RFC – Timeout Resources table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DB2LOTRS table. It is in Development Class for Database Monitor (STU3) ABAP package and is part of the DB2 for z/OS (BC-DB-DB2) module.
SAP DB2LOTRS Table Fields
Following is the list of fields that are available in SAP DB2LOTRS table. The primary key fields of RFC – Timeout Resources table in SAP are LOTRSSSID (DB2 subsystem ID), LOTRSLUUV (Instance number (unique value)), LOTRSDATE (Field of type DATS), LOTRSTIME (Field of type TIMS), LOTRSMSEC (Event time stamp (milliseconds)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| LOTRSSSID | DB2 subsystem ID | DB2SWPSSID | CHAR (4) | |
| LOTRSLUUV | Instance number (unique value) | DB2INSTNO | RAW (12) | |
| LOTRSDATE | Field of type DATS | DATS | DATS (8) | |
| LOTRSTIME | Field of type TIMS | TIMS | TIMS (6) | |
| LOTRSMSEC | Event time stamp (milliseconds) | 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 (10) | |
| LOTRSTC | Timeout intervals that can occur before agent is timed out | DB2W0196CC | NUMC (5) |
