SAP ABAP Table MSSBLOCKINGLOCKHIER (Blocking lock hierarchy display)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSBLOCKINGLOCKHIER	Table Relationship Diagram
Short Description	Blocking lock hierarchy display

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	SEQ_NUM	☐	MSSLCKSEQ		INT4	10	0	Lock sequence number
2	HOSTNAME	☐	MSSHOSTNM_	TEXT30	CHAR	30	0	Hostname of the application server logged into SQL Server
3	PROGNAME	☐	MSSPRGNAME	TEXT30	CHAR	30	0	Name of the application program which owns the connection
4	SESS_ID	☐	MSSSESSIONID	MSSINT4	INT4	10	0	Session ID for SQL Server
5	BLK_SESS_ID	☐	MSSBLKSESSIONID		INT4	10	0	Blocking session ID for SQL Server
6	REQ_ID	☐	MSSREQUESTID		INT4	10	0	SQL Server Request ID
7	WAIT_SEC	☐	MSSWAITSEC		INT4	10	0	Current wait time of the process in seconds
8	SQL_TEXT	☐	MSSLCKSQLTXT		CHAR	128	0	Beginning characters of a sql statement in a lock hierarchy
9	WAIT_TYPE	☐	MSSLCKWAITTYP		CHAR	16	0	Lock wait type
10	WAIT_RES	☐	MSSWAITRSC		CHAR	40	0	Wait Resource as seen in sysprocesses
11	COMMAND	☐	MSSCOMMAND	TEXT16	CHAR	16	0	MS SQL Server command
12	LOCKSTAT	☐	MSSLOCKMODE		CHAR	10	0	req_mod from syslockinfo for blocking/blocked lock entry
13	SQLHANDLE	☐	MSSSQLHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to sql statment or procedure
14	STMT_START_OFFSET	☐	MSSINT4		INT4	10	0	SQL Server int4
15	STMT_END_OFFSET	☐	MSSINT4		INT4	10	0	SQL Server int4
16	PLAN_HANDLE	☐	MSSPLANHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to plan used in execution of sql stmt/proc

History

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