SAP ABAP Table MSSALLLOCKS (Lock information from list of all locks on the server)

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	MSSALLLOCKS	Table Relationship Diagram
Short Description	Lock information from list of all locks on the server

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	SESS_ID	☐	MSSSESSIONID	MSSINT4	INT4	10	0	Session ID for SQL Server
2	ENTITY_ID	☐	MSSENTITYID		DEC	20	0	ID of the entity with which a resource is associated
3	OBJ_NAME	☐	MSSOBJNAME	TEXT30	CHAR	30	0	MS SQL Server object name
4	DB_NAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
5	IND_ID	☐	MSSINDEXID		INT2	5	0	Index id
6	WAITRSC	☐	MSSWAITRSC		CHAR	40	0	Wait Resource as seen in sysprocesses
7	REQ_MODE	☐	MSSREQMODE		CHAR	16	0	Granted mode or mode being requested
8	REQ_STATUS	☐	MSSREQSTATUS		CHAR	16	0	Status: GRANTED, CONVERT, or WAIT.
9	RES_DESC	☐	MSSRESDESC		CHAR	48	0	Lock resource description (dm_tran_locks)
10	OBJ_ID	☐	MSSOBJID		INT4	10	0	Object id

History

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