| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | LOTHWSSID | DB2 subsystem ID | nvarchar | 4 | 0 | CHAR | (N' ') | No | | DB2SWPSSID | Allow NULL? |
| 2 | LOTHWLUUV | Instance number (unique value) | varbinary | 12 | 0 | RAW | | No | | DB2INSTNO | |
| 3 | LOTHWDATE | Field of type DATS | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATS | Allow NULL? |
| 4 | LOTHWTIME | Field of type TIMS | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | TIMS | Allow NULL? |
| 5 | LOTHWMSEC | Event time stamp (milliseconds) | nvarchar | 6 | 0 | CHAR | (N' ') | No | | DB2EVTTMS | Allow NULL? |
| 6 | LOTHWCNT | DB2/390: Unique counter | int | 10 | 0 | INT4 | ((0)) | No | | DB2UCNT | Allow NULL? |
| 7 | LOTHWHW | H=Holder, W = Waiter, and R = Retained | char | 1 | 0 | CHAR | (N' ') | Yes | | DB2W0196HW | Allow NULL? |
| 8 | LOTHWHP | DB2 plan name | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | DB2WHCPLAN | Allow NULL? |
| 9 | LOTHWHB | The authorization ID under which the transaction is running | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | DB2WHCAID | Allow NULL? |
| 10 | LOTHWHN | The connection ID of the thread | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | DB2WHCCN | Allow NULL? |
| 11 | LOTHWHR | The correlation ID of the thread (IP address) | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | DB2WHCCV | Allow NULL? |
| 12 | LOTHWHC | DB2/390: End user ID (in DB2 sense) | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | DB2LEUID | Allow NULL? |
| 13 | LOTHWHJ | End user transaction name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | DB2LEUTX | Allow NULL? |
| 14 | LOTHWHK | End user workstation name | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | DB2LEUWN | Allow NULL? |
| 15 | LOTHWHLUUV | Field type char, length 12 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | DB2CHAR12 | Allow NULL? |
| 16 | LOTHWHT | Holder token | int | 10 | 0 | INT4 | ((0)) | Yes | | DBW0196HT | Allow NULL? |
| 17 | LOTHWHI | DB2 member name in data sharing environment | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | DB2MEMN | Allow NULL? |
| 18 | LOTHWHS | The mode of the lock held on the resource | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | DB2LOCKMS | Allow NULL? |
| 19 | LOTHWHD | Lock duration of the thread holding the resource | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | DB2SWD | Allow NULL? |
| 20 | LOTHWHF | RFC - raw 1 | varbinary | 1 | 0 | RAW | | Yes | | DB2RAW1 | |
