SAP ABAP Table DB2LOCKS_RESOURCE_THREADS (Locked DB2-Resources and their Holders and Waiters)

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

Basic Data

Table Category	INTTAB	Structure
Structure	DB2LOCKS_RESOURCE_THREADS	Table Relationship Diagram
Short Description	Locked DB2-Resources and their Holders and Waiters

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_DB	☐	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)
10	HOLD_WAIT	☐	DB2_HOLD_WAIT	CHAR1	CHAR	1	0	Detectionflag for Holders(H) or Waiters(W) for DB2Resources
11	.INCLUDE	☐				0	0	DB2 Performance Monitor: Thread List
12	HDSUBSYSID	☐	DB2SWPSSID	DB2CHAR04	CHAR	4	0	DB2 subsystem ID
13	HDATDAT	☐	DB2SWPATDT	DB2DATE	DATS	8	0	Date when sampling is taken
14	HDATTIM	☐	DB2SWPATTM	DB2TIME	TIMS	6	0	Time when sampling is taken
15	HDLRESTIME	☐	DB2SWPLRTM	DB2TIME	TIMS	6	0	Time of last reset
16	ACE	☐	DB2RAW04	DB2INT4	INT4	10	0	Field type raw, length 8, 4 bytes
17	JOBNAME	☐	DB2THDJOB	DB2CHAR8	CHAR	8	0	The job name of the thread.
18	DBPLAN	☐	DB2WHCPLAN	CHAR128	CHAR	128	0	DB2 plan name
19	AUTHID	☐	DB2WHCAID	CHAR128	CHAR	128	0	The authorization ID under which the transaction is running
20	CORRID	☐	DB2WHCCV	DB2CHAR16	CHAR	16	0	The correlation ID of the thread (IP address)
21	CONNID	☐	DB2WHCCN	DB2CHAR08	CHAR	8	0	The connection ID of the thread
22	THDSTAT	☐	DB2W0148AI	DB2CHAR16	CHAR	16	0	The status of the thread
23	FILLER	☐	DB2CHAR08	DB2CHAR08	CHAR	8	0	Field type char, length 8
24	SQLCNT	☐	DB2THDSQL	DB2INT4	INT4	10	0	The total number of executed SQL statements
25	DBCOMMIT	☐	DB2WACCOMM	DB2INT4	INT4	10	0	The number of successful phase 2 or single-phase commits
26	ABORT	☐	DB2WACABRT	DB2INT4	INT4	10	0	Total number of rollback requests
27	GETPAGE	☐	DB2BACGET	DB2INT4U	INT4	10	0	Number of Getpage Requests
28	UPDPAGE	☐	DB2BACSWS	DB2INT4U	INT4	10	0	The number of times a buffer update occurs for the agent
29	LOCKS	☐	DB2THDLOCK	DB2INT4	INT4	10	0	The total number of currently hold locks.
30	CPUTIME	☐	DB2WACAJST	DB2INT4	INT4	10	0	The accumulated home CPU time a thread spent in DB2
31	ELTIME	☐	DB2THDELT	DB2INT4	INT4	10	0	Time elapsed since DB2 thread was started
32	LOCKMOD	☐	DB2LOCKMOD	DB2CHAR06	CHAR	6	0	The mode of the lock held on the resource
33	ACTTIME	☐	DB2THDTACT	DB2CHAR16	CHAR	16	0	Activity time (Class 1 elapsed time)
34	TIMEINDB2	☐	DB2INDB2	DB2TIMEP	CHAR	8	0	Percentage of time spent in DB2
35	PROCINDB2	☐	DB2PROCDB2	DB2TIMEP	CHAR	8	0	Percentage of time spent processing in DB2
36	WPTYPE	☐	DB2PROCTYP		CHAR	11	0	process type
37	WPNUMBER	☐	DB2PROCID		NUMC	19	0	process ID
38	WPID	☐	DB2WPID	DB2NUMC10	NUMC	10	0	Work process ID
39	ASHOST	☐	DB2ASHOST	DB2CHAR32	CHAR	32	0	Application server host name
40	THDREQ	☐	DB2W0148RC	DB2INT4	INT4	10	0	Number of Requests Sent to DB2
41	ADTHRSTA	☐	DB2DTHRSTA	DB2CHAR22	CHAR	22	0	Status of the thread
42	PRCINDB2	☐	DB2PRCIN	DB2CHAR10	CHAR	10	0	Thread activity: % processing in DB2
43	SSPINDB2	☐	DB2SSPIN	DB2CHAR10	CHAR	10	0	Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit)
44	DS_MEMBER	☐			CHAR	8	0
45	THDMLOCKS	☐			NUMC	10	0
46	CONNNAME	☐			CHAR	30	0
47	QMDAPLAT	☐			CHAR	18	0
48	QWHDRQNM	☐			CHAR	128	0
49	SAPSID	☐			CHAR	3	0
50	SAPSYS	☐			INT4	10	0
51	ABAPREP	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program	*
52	TXCODE	☐	DB2TXNAME		CHAR	80	0	transaction / thread name
53	ENDUSER	☐			CHAR	14	0
54	J2EESERV	☐			CHAR	20	0
55	QWACPARR	☐			CHAR	10	0
56	QW0148CI	☐			CHAR	128	0
57	QW0148ST	☐	DB2W0148ST		CHAR	2	0	Indicates the status of the conversation or socket
58	.INCLUDE	☐				0	0	Number of Waiters and Holders on a Resource
59	NQW1503H	☐	INT4	INT4	INT4	10	0	Natural number
60	NQW1503W	☐	INT4	INT4	INT4	10	0	Natural number

History

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