SAP ABAP Table DB6MON_APPL_LOCKWAIT (DB6: Lock-waits as of V9.7)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6MON_APPL_LOCKWAIT	Table Relationship Diagram
Short Description	DB6: Lock-waits as of V9.7

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	LOCK_WAIT_START_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
2	WAIT_TIME_MS	☐			DEC	22	0
3	LOCK_NAME	☐			CHAR	32	0
4	LOCK_OBJECT_TYPE	☐			CHAR	32	0
5	LOCK_MODE	☐			STRG	0	0
6	LOCK_CURRENT_MODE	☐			STRG	0	0
7	LOCK_MODE_REQUESTED	☐			STRG	0	0
8	LOCK_STATUS	☐			STRG	0	0
9	LOCK_ESCALATION	☐			CHAR	8	0
10	LOCK_ATTRIBUTES	☐			CHAR	16	0
11	LOCK_RRIID	☐			DEC	22	0
12	LOCK_COUNT	☐			DEC	22	0
13	LOCK_TIMEOUT_VAL	☐			INT4	10	0
14	TBSP_ID	☐			DEC	22	0
15	TAB_FILE_ID	☐			DEC	22	0
16	SUBSECTION_NUMBER	☐			DEC	22	0
17	REQ_APPLICATION_HANDLE	☐			DEC	22	0
18	REQ_AGENT_TID	☐			DEC	22	0
19	REQ_MEMBER	☐			INT4	10	0
20	REQ_EXECUTABLE_ID	☐			RSTR	0	0
21	HLD_APPLICATION_HANDLE	☐			DEC	22	0
22	HLD_MEMBER	☐			INT4	10	0
23	LWE_TYPE	☐			CHAR	32	0
24	TABSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
25	TABNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
26	TBSPACE	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
27	CURRENT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
28	LAST_STMT_TEXT	☐			STRG	0	0
29	LAST_STMT_EFF_ISOLATION	☐			CHAR	2	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	703