SAP MSQBLOLCKS Table in S/4 HANA - MS SQL server blocked locks
MSQBLOLCKS is a standard SAP Table which is used to store MS SQL server blocked locks data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MSQBLOLCKS table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Structure
Database Table: MSQBLOLCKS
MSQBLOLCKS table structure field list
Below is the full MSQBLOLCKS field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
SPID | MS SQL Server process ID | MSQSYPROID | INT2 | 5(0) | INT2 | |||||
OBJECTNAME | Object name as defined in system table sysobjects. | MSQOBJNAME | CHAR | 256(0) | CHAR256 | |||||
LOCKNAME | Lock request mode translated from table sptvalue. | MSQSPTNAME | CHAR | 35(0) | CHAR35 | |||||
KPID | Windows operating system thread ID | MSQTHREDID | INT2 | 5(0) | INT2 | |||||
BLOCKEDBY | SPID of blocking process. | MSQBLOPRID | INT2 | 5(0) | INT2 | |||||
LOCKRSC | Textual description of a lock resource from syslockinfo. | MSQRSCTXT | CHAR | 32(0) | CHAR32 | |||||
DBNAME | The name of the database in SQL Server instance. | MSQDBNAME | CHAR | 255(0) | CHAR255 | |||||
LCKTYPE | Lock resource type as e. g. KEY or PAGE. | MSQLCKRSC | CHAR | 10(0) | CHAR10 | |||||
RSCLCKBIN | MS SQL server - binary lock resource | MSQRSCBIN | RAW | 16(0) | MSQHEX16 | |||||
LCKVALBLK | MS SQL server - lock value block. | MSQRSCLKBK | RAW | 16(0) | MSQHEX16 | |||||
INDNAME | MS SQL server table or index name | MSQTABNAME | CHAR | 256(0) | CHAR256 | |||||
LCKSTATUS | Lock request mode translated from table sptvalue. | MSQSPTNAME | CHAR | 35(0) | CHAR35 | |||||
LCKREFCNT | MS SQL server - lock reference count | MSQLKRECNT | INT2 | 5(0) | INT2 | |||||
LCKCARCNT | MS SQL server - lock carry-over reference count | MSQLKCRYCT | INT2 | 5(0) | INT2 | |||||
LCKLFETIME | MS SQL server - lock lifetime bitmap. | MSQLKLFTIM | INT4 | 10(0) | INT4 | |||||
ECID | Execution context ID used to uniquely identify subthreads | MSQECID | INT4 | 10(0) | INT4 | |||||
LCKOWNER | MS SQL server - type of object associated with a lock | MSQLCKOWN | INT2 | 5(0) | INT2 | |||||
PROSSTAT | SQL Server process status; ie sleeping, running etc. | MSQPRSTAT | CHAR | 60(0) | CHAR60 | |||||
PROSUSER | The user name used to log into the SQL Server database | MSQUSRNAME | CHAR | 128(0) | CHAR128 | |||||
HOSTNAME | Hostname of the application server logged into SQL Server. | MSQHOSTNAM | CHAR | 256(0) | CHAR256 | |||||
PROGNAME | Name of the application program which owns the connection. | MSQAPPPROG | CHAR | 256(0) | CHAR256 | |||||
WAITTYPE | Wait type of waiting process, reserved field of sysprocesses | MSQWAITTYP | INT2 | 5(0) | INT2 | |||||
EXECCMD | Command currently being executed by the given process id | MSQEXECMD | CHAR | 32(0) | CHAR32 | |||||
HOSTPROS | The application program's process ID on the given host | MSQWKPROID | CHAR | 16(0) | CHAR16 |
Search for further information about these or an SAP related objects