SAP Table MSSDBLOCKS
structure returned about blocking db locks for SQL Server
MSSDBLOCKS (structure returned about blocking db locks for SQL Server) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MSSDBLOCKS to other SAP tables.
MSSDBLOCKS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| ACTFLAG | INT4 | 10 | 0 | |||||
| FIRSTOCCUR | CHAR | 23 | 0 | |||||
| REQSPID | MS SQL Server process ID | MSSREQSPID | INT2 | 5 | 0 | |||
| HOLDSPID | MS SQL Server process ID (blocking) | MSSBLKSPID | INT2 | 5 | 0 | |||
| REQPID | MS SQL-Server host process id (= OS work process ID) | MSSHOSTPID | CHAR | 8 | 0 | |||
| OPEN_TRAN | Number of open transactions for the SQL Server process | MSSOPENTRAN | INT4 | 10 | 0 | |||
| PROCSTAT | MS SQL-Server process status | MSSSTATUS | CHAR | 10 | 0 | |||
| USERNAME | MS SQL Server user name | MSSUNAME | CHAR | 30 | 0 | |||
| HOSTNAME | Hostname of the application server logged into SQL Server | MSSHOSTNM_ | CHAR | 30 | 0 | |||
| PROGNAME | Name of the application program which owns the connection | MSSPRGNAME | CHAR | 30 | 0 | |||
| COMMAND | MS SQL Server command | MSSCOMMAND | CHAR | 16 | 0 | |||
| INPUTBUFF | Output from DBCC INPUTBUFFER for lock display | MSSINPUTBUFF | CHAR | 40 | 0 | |||
| WAITTIME | Current wait time of the process in milliseconds | MSSWAITTIME | INT4 | 10 | 0 | |||
| WAITRSC | Wait Resource as seen in sysprocesses | MSSWAITRSC | CHAR | 40 | 0 | |||
| LASTWTYPE | Last Wait Type as seen in sysprocesses | MSSLASTWTYPE | CHAR | 32 | 0 | |||
| DBNAME | MS SQL Server: Database name | MSSLDBNAME | CHAR | 30 | 0 | |||
| OBJNAME | Table name | MSSTNAME | CHAR | 30 | 0 | |||
| INDEXNAME | MS SQL Server object name | MSSOBJNAME | CHAR | 30 | 0 | |||
| LOCKRSC | Textual description of a lock resource from syslockinfo | MSSLOCKRSC | CHAR | 32 | 0 | |||
| LOCKTYPE | Char representation of rsc_type from syslockinfo | MSSCHARLOCKTYP | CHAR | 10 | 0 | |||
| LOCKNAME | MS SQL Server lock description text | MSSLOCKTXT | CHAR | 35 | 0 | |||
| LOCKSTAT | req_mod from syslockinfo for blocking/blocked lock entry | MSSLOCKMODE | CHAR | 10 | 0 | |||
| REQ_REFCNT | req_refcnt from syslockinfo for blocking/blocked lock entry | MSSREQREFCNT | INT4 | 10 | 0 | |||
| REQ_OWNERTYPE | req_refcnt from syslockinfo for blocking/blocked lock entry | MSSREQOWNTYP | CHAR | 12 | 0 | |||
