SAP ABAP Table MSSLOCKINF (MS SQL-Server: Lock Information)
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
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 | MSSLOCKINF |
Table Relationship Diagram 
|
| Short Description | MS SQL-Server: Lock Information |
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 |  SPID |
MSSSPID | INT2 | INT2 | 5 | 0 | MS SQL Server process ID | ||
| 2 | KPID |
MSSKPID | INT2 | INT2 | 5 | 0 | Windows NT thread ID | ||
| 3 | STATUS |
MSSSTATUS | TEXT10 | CHAR | 10 | 0 | MS SQL-Server process status | ||
| 4 | USERNAME |
MSSUNAME | TEXT30 | CHAR | 30 | 0 | MS SQL Server user name | ||
| 5 | HOSTNAME |
MSSHOSTNM_ | TEXT30 | CHAR | 30 | 0 | Hostname of the application server logged into SQL Server | ||
| 6 | PROGNAME |
MSSPRGNAME | TEXT30 | CHAR | 30 | 0 | Name of the application program which owns the connection | ||
| 7 | HOSTPROC |
MSSHOSTPID | WPPID | CHAR | 8 | 0 | MS SQL-Server host process id (= OS work process ID) | ||
| 8 | COMMAND |
MSSCOMMAND | TEXT16 | CHAR | 16 | 0 | MS SQL Server command | ||
| 9 | BLOCKERPID |
MSSBLOCKED | INT2 | INT2 | 5 | 0 | MS SQL Server sp ID of blocking process | ||
| 10 | WAITTYPE |
MSSWAITTYP | CHAR1 | CHAR | 1 | 0 | MS SQL Server wait type | ||
| 11 | DBNAME |
MSSLDBNAME | TEXT30 | CHAR | 30 | 0 | MS SQL Server: Database name | ||
| 12 | LOCKID |
MSSLOCKID | INT4 | INT4 | 10 | 0 | MS SQL-Server lock ID | ||
| 13 | LOCKEDPAGE |
MSSLOCKPG | INT4 | INT4 | 10 | 0 | MS SQL Server locked page number | ||
| 14 | LOCKTYPE |
MSSLOCKTYP | INT2 | INT2 | 5 | 0 | MS SQL Server lock type number | ||
| 15 | LOCKTEXT |
MSSLOCKTXT | TEXT35 | CHAR | 35 | 0 | MS SQL Server lock description text | ||
| 16 | OBJECTNAME |
MSSOBJNAME | TEXT30 | CHAR | 30 | 0 | MS SQL Server object name | ||
| 17 | OBJECTTYPE |
MSSOBJTYPE | CHAR | 2 | 0 | Object type | |||
| 18 | SAPUSER |
WPBNAME | UBNAME | CHAR | 12 | 0 | User Currently Served | ||
| 19 | REPORTNAME |
WPREPORT | WPREPORT | CHAR | 40 | 0 | Report now running | ||
| 20 | NESTLEVEL |
NESTLEVEL | INT2 | INT2 | 5 | 0 | Nesting level for lock waiters |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
