Data Element list used by SAP ABAP Table MSSDBLOCKS (structure returned about blocking db locks for SQL Server)
SAP ABAP Table
MSSDBLOCKS (structure returned about blocking db locks for SQL Server) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
![]() |
![]() |
|||
1 | ![]() |
MSSBLKSPID | MS SQL Server process ID (blocking) | |
2 | ![]() |
MSSCHARLOCKTYP | Char representation of rsc_type from syslockinfo | |
3 | ![]() |
MSSCOMMAND | MS SQL Server command | |
4 | ![]() |
MSSHOSTNM_ | Hostname of the application server logged into SQL Server | |
5 | ![]() |
MSSHOSTPID | MS SQL-Server host process id (= OS work process ID) | |
6 | ![]() |
MSSINPUTBUFF | Output from DBCC INPUTBUFFER for lock display | |
7 | ![]() |
MSSLASTWTYPE | Last Wait Type as seen in sysprocesses | |
8 | ![]() |
MSSLDBNAME | MS SQL Server: Database name | |
9 | ![]() |
MSSLOCKMODE | req_mod from syslockinfo for blocking/blocked lock entry | |
10 | ![]() |
MSSLOCKRSC | Textual description of a lock resource from syslockinfo | |
11 | ![]() |
MSSLOCKTXT | MS SQL Server lock description text | |
12 | ![]() |
MSSOBJNAME | MS SQL Server object name | |
13 | ![]() |
MSSOPENTRAN | Number of open transactions for the SQL Server process | |
14 | ![]() |
MSSPRGNAME | Name of the application program which owns the connection | |
15 | ![]() |
MSSREQOWNTYP | req_refcnt from syslockinfo for blocking/blocked lock entry | |
16 | ![]() |
MSSREQREFCNT | req_refcnt from syslockinfo for blocking/blocked lock entry | |
17 | ![]() |
MSSREQSPID | MS SQL Server process ID | |
18 | ![]() |
MSSSTATUS | MS SQL-Server process status | |
19 | ![]() |
MSSTNAME | Table name | |
20 | ![]() |
MSSUNAME | MS SQL Server user name | |
21 | ![]() |
MSSWAITRSC | Wait Resource as seen in sysprocesses | |
22 | ![]() |
MSSWAITTIME | Current wait time of the process in milliseconds |