SAP ABAP Table DB2DEADLK_TREE (Structure for Deadlocks ALV Tree)

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	DB2DEADLK_TREE	Table Relationship Diagram
Short Description	Structure for Deadlocks ALV Tree

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	NAME	☐			STRG	0	0
2	DLKDATE	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
3	DLKTIME	☐	DB2CHAR16	DB2CHAR16	CHAR	16	0	Field type char, length 16
4	DBNAME	☐	DB2DBOWNER	DB2CHAR16	CHAR	16	0	The name of the DB2 database
5	RSOBJNAME	☐	DB2PAGES2	DB2CHAR18	CHAR	18	0	Object name
6	RSPAGENR	☐	DB2PAGENR	DB2CHAR10	CHAR	10	0	Page number
7	LOCKTYPE	☐	DB2RESTYPE	CHAR20	CHAR	20	0	The type of resource held by a lock
8	RSROWID	☐	DB2PARTNR	DB2CHAR03	CHAR	3	0	Row ID or partition number, depending on resource type
9	MEMBER	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
10	WPTYPE	☐	DB2PROCTYP		CHAR	11	0	process type
11	WPNUMBER	☐			NUMC	3	0
12	WPID	☐			NUMC	10	0
13	ASHOST	☐	DB2ASHOST	DB2CHAR32	CHAR	32	0	Application server host name
14	SQLTEXT	☐	DB2QSTSTMT		CHAR	255	0	Statement text
15	SQLID	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
16	SAPSID	☐			CHAR	3	0
17	ABAPREP	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program	*
18	ENDUSER	☐			CHAR	14	0
19	AGGREGATE	☐			STRG	0	0
20	IS_AGGREGATE	☐			CHAR	4	0
21	ORIGINTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
22	DLKMSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
23	FLAG	☐			STRG	0	0
24	NODE_KEY	☐			INT1	3	0
25	RESNUMBER	☐	DB2UCNT		INT4	10	0	DB2/390: Unique counter

History

Last changed by/on	SAP	20141013
SAP Release Created in