SAP ABAP Table DB2_VIEW_DLK_DET (View Structure for Deadlock Details)

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	DB2_VIEW_DLK_DET	Table Relationship Diagram
Short Description	View Structure for Deadlock Details

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

History

Last changed by/on	SAP	20141013
SAP Release Created in