SAP ABAP Table DB2LOCKRES (Resources locked by 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	DB2LOCKRES	Table Relationship Diagram
Short Description	Resources locked by 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	T3ACE	☐	DB2ACEID	DB2RAW04	RAW	4	0	ACE ID of the thread
2	T3DBNAME	☐	DB2T3DBNAM	DB2CHAR08	CHAR	8	0	Name of the database
3	T3OBNAME	☐	DB2T3OBNAM	DB2CHAR18	CHAR	18	0	Name of the object associated with the database
4	T3LOCKS	☐	DB2T3LOCKS	DB2NUMC05	NUMC	5	0	No. of locks held and susp. on the database/obj. combination
5	T3TYPE	☐	DB2T3TYPE	DB2CHAR08	CHAR	8	0	Type of lock held on a resource
6	T3STATE	☐	DB2T3STATE	DB2CHAR03	CHAR	3	0	State of the lock held on the resource
7	T3DURAT	☐	DB2T3DURAT	DB2CHAR16	CHAR	16	0	Duration of a lock
8	T3SUSP	☐	DB2T3SUSP	DB2CHAR09	CHAR	9	0	Whether the thread is suspended waiting for a lock
9	T3FUNCT	☐	DB2T3FUNCT	DB2CHAR16	CHAR	16	0	IRLM function request
10	T3COLL	☐	DB2T3COLL	DB2CHAR18	CHAR	18	0	Name of the package collection
11	T3PACK	☐	DB2T3PACK	DB2CHAR08	CHAR	8	0	Package identifier
12	T3CONST	☐	DB2T3CONST	DB2CHAR19	CHAR	19	0	Consistency token of the package
13	T3PLLCK	☐	DB2T3PLLCK	DB2CHAR06	CHAR	6	0	Indicates the kind of lock for the resource
14	T3PART	☐	DB2T3PART	DB2NUMC05	NUMC	5	0	Partition of the locked resource
15	T3SUBP	☐	DB2T3SUBP	DB2NUMC05	NUMC	5	0	Subpage number of the index page lock
16	T3ROW	☐	DB2T3ROW	DB2NUMC05	NUMC	5	0	Record ID within the page of the locked resource
17	T3PAGE	☐	DB2T3PAGE	DB2NUMC09	NUMC	9	0	Page number of the locked resource
18	T3BPID	☐	DB2T3BPID	DB2CHAR08	CHAR	8	0	Buffer pool ID of the locked resource
19	T3RMID	☐	DB2T3RMID	DB2CHAR08	CHAR	8	0	RMID of the group databases exception update lock
20	T3HASH	☐	DB2T3HASH	DB2NUMC08	NUMC	8	0	Hash class number of the group database exception upd. lock
21	DS_MEMBER	☐			CHAR	8	0

History

Last changed by/on	SAP	20070813
SAP Release Created in	700