SAP ABAP Table MSSDBLOCKS (structure returned about blocking db locks for SQL 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	MSSDBLOCKS	Table Relationship Diagram
Short Description	structure returned about blocking db locks for SQL 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	ACTFLAG	☐			INT4	10	0
2	FIRSTOCCUR	☐			CHAR	23	0
3	REQSPID	☐	MSSREQSPID	INT2	INT2	5	0	MS SQL Server process ID
4	HOLDSPID	☐	MSSBLKSPID	INT2	INT2	5	0	MS SQL Server process ID (blocking)
5	REQPID	☐	MSSHOSTPID	WPPID	CHAR	8	0	MS SQL-Server host process id (= OS work process ID)
6	OPEN_TRAN	☐	MSSOPENTRAN		INT4	10	0	Number of open transactions for the SQL Server process
7	PROCSTAT	☐	MSSSTATUS	TEXT10	CHAR	10	0	MS SQL-Server process status
8	USERNAME	☐	MSSUNAME	TEXT30	CHAR	30	0	MS SQL Server user name
9	HOSTNAME	☐	MSSHOSTNM_	TEXT30	CHAR	30	0	Hostname of the application server logged into SQL Server
10	PROGNAME	☐	MSSPRGNAME	TEXT30	CHAR	30	0	Name of the application program which owns the connection
11	COMMAND	☐	MSSCOMMAND	TEXT16	CHAR	16	0	MS SQL Server command
12	INPUTBUFF	☐	MSSINPUTBUFF		CHAR	40	0	Output from DBCC INPUTBUFFER for lock display
13	WAITTIME	☐	MSSWAITTIME		INT4	10	0	Current wait time of the process in milliseconds
14	WAITRSC	☐	MSSWAITRSC		CHAR	40	0	Wait Resource as seen in sysprocesses
15	LASTWTYPE	☐	MSSLASTWTYPE		CHAR	32	0	Last Wait Type as seen in sysprocesses
16	DBNAME	☐	MSSLDBNAME	TEXT30	CHAR	30	0	MS SQL Server: Database name
17	OBJNAME	☐	MSSTNAME	AS4TAB	CHAR	30	0	Table name	*
18	INDEXNAME	☐	MSSOBJNAME	TEXT30	CHAR	30	0	MS SQL Server object name
19	LOCKRSC	☐	MSSLOCKRSC		CHAR	32	0	Textual description of a lock resource from syslockinfo
20	LOCKTYPE	☐	MSSCHARLOCKTYP		CHAR	10	0	Char representation of rsc_type from syslockinfo
21	LOCKNAME	☐	MSSLOCKTXT	TEXT35	CHAR	35	0	MS SQL Server lock description text
22	LOCKSTAT	☐	MSSLOCKMODE		CHAR	10	0	req_mod from syslockinfo for blocking/blocked lock entry
23	REQ_REFCNT	☐	MSSREQREFCNT		INT4	10	0	req_refcnt from syslockinfo for blocking/blocked lock entry
24	REQ_OWNERTYPE	☐	MSSREQOWNTYP		CHAR	12	0	req_refcnt from syslockinfo for blocking/blocked lock entry

History

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