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