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
SPIDMS SQL Server process IDMSQSYPROIDINT25(0) INT2
OBJECTNAMEObject name as defined in system table sysobjects.MSQOBJNAMECHAR256(0) CHAR256
LOCKNAMELock request mode translated from table sptvalue.MSQSPTNAMECHAR35(0) CHAR35
KPIDWindows operating system thread IDMSQTHREDIDINT25(0) INT2
BLOCKEDBYSPID of blocking process.MSQBLOPRIDINT25(0) INT2
LOCKRSCTextual description of a lock resource from syslockinfo.MSQRSCTXTCHAR32(0) CHAR32
DBNAMEThe name of the database in SQL Server instance.MSQDBNAMECHAR255(0) CHAR255
LCKTYPELock resource type as e. g. KEY or PAGE.MSQLCKRSCCHAR10(0) CHAR10
RSCLCKBINMS SQL server - binary lock resourceMSQRSCBINRAW16(0) MSQHEX16
LCKVALBLKMS SQL server - lock value block.MSQRSCLKBKRAW16(0) MSQHEX16
INDNAMEMS SQL server table or index nameMSQTABNAMECHAR256(0) CHAR256
LCKSTATUSLock request mode translated from table sptvalue.MSQSPTNAMECHAR35(0) CHAR35
LCKREFCNTMS SQL server - lock reference countMSQLKRECNTINT25(0) INT2
LCKCARCNTMS SQL server - lock carry-over reference countMSQLKCRYCTINT25(0) INT2
LCKLFETIMEMS SQL server - lock lifetime bitmap.MSQLKLFTIMINT410(0) INT4
ECIDExecution context ID used to uniquely identify subthreadsMSQECIDINT410(0) INT4
LCKOWNERMS SQL server - type of object associated with a lockMSQLCKOWNINT25(0) INT2
PROSSTATSQL Server process status; ie sleeping, running etc.MSQPRSTATCHAR60(0) CHAR60
PROSUSERThe user name used to log into the SQL Server databaseMSQUSRNAMECHAR128(0) CHAR128
HOSTNAMEHostname of the application server logged into SQL Server.MSQHOSTNAMCHAR256(0) CHAR256
PROGNAMEName of the application program which owns the connection.MSQAPPPROGCHAR256(0) CHAR256
WAITTYPEWait type of waiting process, reserved field of sysprocessesMSQWAITTYPINT25(0) INT2
EXECCMDCommand currently being executed by the given process idMSQEXECMDCHAR32(0) CHAR32
HOSTPROSThe application program's process ID on the given hostMSQWKPROIDCHAR16(0) CHAR16




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!