SAP ABAP Table DB2LOCKESCPROC (DB2 for z/OS: Postprocessed lock escalations (IFCID 337))

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	DB2LOCKESCPROC	Table Relationship Diagram
Short Description	DB2 for z/OS: Postprocessed lock escalations (IFCID 337)

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	DB2 alert for lock escalations
2	LOCKMEMN	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
3	SSID	☐	DB2SWPSSID	DB2CHAR04	CHAR	4	0	DB2 subsystem ID
4	LOCKDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
5	LOCKTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
6	LOCKMSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
7	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
8	TSNAME	☐	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
9	QWO337LS	☐	DB2LOCKMS	DB2CHAR03	CHAR	3	0	The mode of the lock held on the resource
10	QW0337LL	☐			CHAR	10	0
11	QW0337LH	☐			INT4	10	0
12	QW0337SN	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
13	QW0337ST	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
14	QW0337CI	☐			CHAR	128	0
15	QW0337PK	☐			CHAR	128	0
16	THDEUWN	☐	DB2EUWN	DB2CHAR18	CHAR	18	0
17	THDEUTX	☐	DB2EUTX	CHAR32	CHAR	32	0
18	QMDASUFX	☐			CHAR	200	0
19	QMDAPLAT	☐			CHAR	18	0
20	QWHDRQNM	☐			CHAR	128	0
21	QWHCEUID	☐			CHAR	128	0
22	CORRID	☐	DB2WHCCV	DB2CHAR16	CHAR	16	0	The correlation ID of the thread (IP address)
23	CONNID	☐	DB2WHCCN	DB2CHAR08	CHAR	8	0	The connection ID of the thread
24	LOCKDSGN	☐	DB2DSGN	DB2CHAR08	CHAR	8	0	DB2/390: Data sharing group
25	WPTYPE	☐	DB2WPTYE	DB2CHAR05	CHAR	5	0	Corresponding R/3 work process type
26	WPNUMBER	☐	DB2WPNUM	DB2NUMC10	NUMC	10	0	Work process number
27	WPID	☐	DB2WPID	DB2NUMC10	NUMC	10	0	Work process ID
28	ASHOST	☐	DB2ASHOST	DB2CHAR32	CHAR	32	0	Application server host name
29	CONNNAME	☐			CHAR	30	0
30	SAPSID	☐			CHAR	3	0
31	ABAPREP	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program	*
32	TXCODE	☐			CHAR	20	0
33	ENDUSER	☐			CHAR	14	0
34	J2EESERV	☐			CHAR	20	0

History

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