SAP ABAP Table DB2DEADRS (RFC - Deadlock Structure Resources, Holder and Waiter)

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	DB2DEADRS	Table Relationship Diagram
Short Description	RFC - Deadlock Structure Resources, Holder and Waiter

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	.INCLUDE	☐				0	0	RFC - Deadlock Resources
2	LODRSSSID	☐	DB2SWPSSID	DB2CHAR04	CHAR	4	0	DB2 subsystem ID
3	LODRSLUUV	☐	DB2INSTNO	DB2RAW12	RAW	12	0	Instance number (unique value)
4	LODRSDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
5	LODRSTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
6	LODRSMSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
7	LODRSCNT	☐	DB2UCNT		INT4	10	0	DB2/390: Unique counter
8	LODRSFR	☐	DB2RESTYPE	CHAR20	CHAR	20	0	The type of resource held by a lock
9	LODRSKD	☐	DB2DBOWNER	DB2CHAR16	CHAR	16	0	The name of the DB2 database
10	LODRSKP	☐	DB2PAGES2	DB2CHAR18	CHAR	18	0	Object name
11	LODRSK1	☐	DB2PAGENR	DB2CHAR10	CHAR	10	0	Page number
12	LODRSK2	☐	DB2PARTNR	DB2CHAR03	CHAR	3	0	Row ID or partition number, depending on resource type
13	LODRSHP	☐	DB2WHCPLAN	CHAR128	CHAR	128	0	DB2 plan name
14	LODRSHB	☐	DB2WHCAID	CHAR128	CHAR	128	0	The authorization ID under which the transaction is running
15	LODRSHN	☐	DB2WHCCN	DB2CHAR08	CHAR	8	0	The connection ID of the thread
16	LODRSHR	☐	DB2WHCCV	DB2CHAR16	CHAR	16	0	The correlation ID of the thread (IP address)
17	LODRSHC	☐	DB2LEUID	CHAR128	CHAR	128	0	DB2/390: End user ID (in DB2 sense)
18	LODRSHJ	☐	DB2LEUTX	DB2CHAR32	CHAR	32	0	End user transaction name
19	LODRSHK	☐	DB2LEUWN	DB2CHAR18	CHAR	18	0	End user workstation name
20	LODRSHACCT	☐			CHAR	200	0
21	LODRSHLUUV	☐	DB2INSTNO	DB2RAW12	RAW	12	0	Instance number (unique value)
22	LODRSHT	☐	DB2UCNT		INT4	10	0	DB2/390: Unique counter
23	LODRSHI	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
24	LODRSHS	☐	DB2LOCKMS	DB2CHAR03	CHAR	3	0	The mode of the lock held on the resource
25	LODRSHD	☐	DB2SWD	DB2CHAR12	CHAR	12	0	Lock duration of the thread holding the resource
26	LODRSHF	☐	DB2RAW1	DB2RAW1	RAW	1	0	RFC - raw 1
27	LODRSWP	☐	DB2WHCPLAN	CHAR128	CHAR	128	0	DB2 plan name
28	LODRSWB	☐	DB2WHCAID	CHAR128	CHAR	128	0	The authorization ID under which the transaction is running
29	LODRSWN	☐	DB2WHCCN	DB2CHAR08	CHAR	8	0	The connection ID of the thread
30	LODRSWR	☐	DB2WHCCV	DB2CHAR16	CHAR	16	0	The correlation ID of the thread (IP address)
31	LODRSWC	☐	DB2LEUID	CHAR128	CHAR	128	0	DB2/390: End user ID (in DB2 sense)
32	LODRSWJ	☐	DB2LEUTX	DB2CHAR32	CHAR	32	0	End user transaction name
33	LODRSWK	☐	DB2LEUWN	DB2CHAR18	CHAR	18	0	End user workstation name
34	LODRSWACCT	☐			CHAR	200	0
35	LODRSWLUUV	☐	DB2INSTNO	DB2RAW12	RAW	12	0	Instance number (unique value)
36	LODRSWT	☐	DB2UCNT		INT4	10	0	DB2/390: Unique counter
37	LODRSWI	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
38	LODRSWF	☐	DB2SWU	DB2CHAR06	CHAR	6	0	IRLM function request (LOCK, UNLOCK, or CHANGE)
39	LODRSWS	☐	DB2LOCKMS	DB2CHAR03	CHAR	3	0	The mode of the lock held on the resource
40	LODRSWD	☐	DB20172WD	DB2CHAR12	CHAR	12	0	DB2/390: Waiter duration
41	LODRSWG	☐	DB2RAW1	DB2RAW1	RAW	1	0	RFC - raw 1
42	LODRSWA	☐	DB2W0196TC	DB2INT4	INT4	10	0	Timeout intervals that can occur before agent is timed out
43	LODRSHSTID	☐	DB2RHSTID	DB2INT4	INT4	10	0
44	LODRSWSTID	☐	DB2RWSTID	DB2INT4	INT4	10	0
45	RZ20	☐			CHAR	10	0
46	E2E	☐			CHAR	10	0
47	HWPTYPE	☐	DB2PROCTYP		CHAR	11	0	process type
48	HWPNUMBER	☐	DB2PROCID		NUMC	19	0	process ID
49	HWPID	☐	DB2WPID	DB2NUMC10	NUMC	10	0	Work process ID
50	HASHOST	☐	DB2ASHOST	DB2CHAR32	CHAR	32	0	Application server host name
51	WWPTYPE	☐	DB2PROCTYP		CHAR	11	0	process type
52	WWPNUMBER	☐	DB2PROCID		NUMC	19	0	process ID
53	WWPID	☐	DB2WPID	DB2NUMC10	NUMC	10	0	Work process ID
54	WASHOST	☐	DB2ASHOST	DB2CHAR32	CHAR	32	0	Application server host name
55	MEMBER	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
56	HOLDERSQL	☐	DB2QSTSTMT		CHAR	255	0	Statement text
57	HSQLTOKN	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
58	HSQLSTNM	☐	DB2QSTSTNM	DB2RAW16	RAW	16	0	DB2 statement name
59	WAITERSQL	☐	DB2QSTSTMT		CHAR	255	0	Statement text
60	WSQLTOKN	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
61	WSQLSTNM	☐	DB2QSTSTNM	DB2RAW16	RAW	16	0	DB2 statement name
62	HCONNAME	☐			CHAR	30	0
63	WCONNAME	☐			CHAR	30	0
64	HSAPSID	☐			CHAR	3	0
65	HABAPREP	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program	*
66	HTXCODE	☐	DB2TXNAME		CHAR	80	0	transaction / thread name
67	HENDUSER	☐			CHAR	14	0
68	HJ2EESER	☐			CHAR	20	0
69	WSAPSID	☐			CHAR	3	0
70	WABAPREP	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program	*
71	WTXCODE	☐	DB2TXNAME		CHAR	80	0	transaction / thread name
72	WENDUSER	☐			CHAR	14	0
73	WJ2EESER	☐			CHAR	20	0

History

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