SAP ABAP Table DB2QTHDLR (DB2 CL - Locked Resources for a thread)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	DB2QTHDLR	Table Relationship Diagram
Short Description	DB2 CL - 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	☑	DB2USERID	DB2SINT	INT2	5	0
2	ACE	☑	DB2RAW04	DB2INT4	INT4	10	0	Field type raw, length 8, 4 bytes
3	LOCKID	☑	DB2SINT	DB2INT2V	INT2	5	0	Small integer (2 bytes)
4	HOLDWAIT	☑	DB2HDWT	CHAR1	CHAR	1	0
5	HRESTOKEN	☑	DB2RESTOKN		RAW	36	0	hash and resource token
6	MEMBER	☑	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
7	LOCKMOD	☐	DB2LOCKMOD	DB2CHAR06	CHAR	6	0	The mode of the lock held on the resource
8	RESTYPE	☐	DB2RESTYPE	CHAR20	CHAR	20	0	The type of resource held by a lock
9	DB_ID	☐	DB2DBID	INT2	INT2	5	0	DBID
10	OB_ID	☐	DB2OBID	INT2	INT2	5	0	DB2 page set ID
11	DURATION	☐	DB2LOCKDUR	CHAR12	CHAR	12	0	Lock duration of the thread holding the resource
12	LOCKTYPE	☐	DB2LOCKTYP	CHAR10	CHAR	10	0	State of lock
13	LOCKATRI	☐	DB2LOCKATT	CHAR6	CHAR	6	0	Lock attribute (logical lock or physical lock)
14	PAGESET	☐	DB2PAGESET	DB2CHAR22	CHAR	22	0	Object name
15	DBOWNER	☐	DB2DBOWNER	DB2CHAR16	CHAR	16	0	The name of the DB2 database

History

Last changed by/on	SAP	20130604
SAP Release Created in	620