SAP ABAP Table DB2LOCKSH (Locked Resources for a Thread)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU2 (Package) CCMS for DB2 for OS/390
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Table Category | INTTAB | Structure |
| Structure | DB2LOCKSH |
Table Relationship Diagram 
|
| Short Description | Locked Resources for a Thread |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  USERID |
DB2SUCNT | INT2 | INT2 | 5 | 0 | DB2/OS390: Unique counter | ||
| 2 | LOCKID |
DB2SINT | DB2INT2V | INT2 | 5 | 0 | Small integer (2 bytes) | ||
| 3 | LOCKMOD |
DB2LOCKMOD | DB2CHAR06 | CHAR | 6 | 0 | The mode of the lock held on the resource | ||
| 4 | RESTYPE |
DB2RESTYPE | CHAR20 | CHAR | 20 | 0 | The type of resource held by a lock | ||
| 5 | DBOWNER |
DB2DBOWNER | DB2CHAR16 | CHAR | 16 | 0 | The name of the DB2 database | ||
| 6 | PAGESET |
DB2PAGESET | DB2CHAR22 | CHAR | 22 | 0 | Object name | ||
| 7 | DURATION |
DB2LOCKDUR | CHAR12 | CHAR | 12 | 0 | Lock duration of the thread holding the resource | ||
| 8 | LOCKTYPE |
DB2LOCKTYP | CHAR10 | CHAR | 10 | 0 | State of lock | ||
| 9 | LOCKATRI |
DB2LOCKATT | CHAR6 | CHAR | 6 | 0 | Lock attribute (logical lock or physical lock) |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
