SAP ABAP Table DB2DEADLK (RFC - Deadlock Structure)

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	DB2DEADLK	Table Relationship Diagram
Short Description	RFC - Deadlock Structure

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 Table
2	LODLKSSID	☐	DB2SWPSSID	DB2CHAR04	CHAR	4	0	DB2 subsystem ID
3	LODLKLUUV	☐	DB2INSTNO	DB2RAW12	RAW	12	0	Instance number (unique value)
4	LODLKDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
5	LODLKTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
6	LODLKMSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
7	LODLKPLAN	☐	DB2WHCPLAN	CHAR128	CHAR	128	0	DB2 plan name
8	LODLKCN	☐	DB2WHCCN	DB2CHAR08	CHAR	8	0	The connection ID of the thread
9	LODLKCV	☐	DB2WHCCV	DB2CHAR16	CHAR	16	0	The correlation ID of the thread (IP address)
10	LODLKAID	☐	DB2WHCAID	CHAR128	CHAR	128	0	The authorization ID under which the transaction is running
11	LODLKEUID	☐	DB2LEUID	CHAR128	CHAR	128	0	DB2/390: End user ID (in DB2 sense)
12	LODLKEUTX	☐	DB2LEUTX	DB2CHAR32	CHAR	32	0	End user transaction name
13	LODLKEUWN	☐	DB2LEUWN	DB2CHAR18	CHAR	18	0	End user workstation name
14	LODLKACCT	☐			CHAR	200	0
15	LODLKDSGN	☐	DB2DSGN	DB2CHAR08	CHAR	8	0	DB2/390: Data sharing group
16	LODLKMEMN	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
17	LODLKIT	☐	DB2W0172IT	DB2NUMC10	NUMC	10	0	DB2/390: Deadlock interval counter
18	LODLKNR	☐	DB2W0172NR	DB2NUMC10	NUMC	10	0	Number of resources
19	RZ20	☐			CHAR	10	0
20	E2E	☐			CHAR	10	0
21	WPTYPE	☐	DB2WPTYE	DB2CHAR05	CHAR	5	0	Corresponding R/3 work process type
22	WPNUMBER	☐	DB2WPNUM	DB2NUMC10	NUMC	10	0	Work process number
23	WPID	☐	DB2WPID	DB2NUMC10	NUMC	10	0	Work process ID
24	ASHOST	☐	DB2ASHOST	DB2CHAR32	CHAR	32	0	Application server host name
25	MEMBER	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
26	CONNNAME	☐			CHAR	30	0
27	SAPSID	☐			CHAR	3	0
28	ABAPREP	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program	*
29	TXCODE	☐			CHAR	20	0
30	ENDUSER	☐			CHAR	14	0
31	J2EESERV	☐			CHAR	20	0

History

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