SAP ABAP Table MSSDBLOCKS_SNAP (DB Locks snapshot - includes handles)

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_SNAP	Table Relationship Diagram
Short Description	DB Locks snapshot - includes handles

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