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