SAP ABAP Table MSSDBLOCKS_WP (MS SQL Server lock monitor)

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_WP	Table Relationship Diagram
Short Description	MS SQL Server lock monitor

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

History

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