SAP ABAP Table MSQBLOLCKS (MS SQL server blocked locks)
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
Basic Data
Table Category INTTAB    Structure 
Structure MSQBLOLCKS   Table Relationship Diagram
Short Description MS SQL server blocked locks    
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 MSQSYPROID INT2 INT2 5   0   MS SQL Server process ID  
2 OBJECTNAME MSQOBJNAME CHAR256 CHAR 256   0   Object name as defined in system table sysobjects.  
3 LOCKNAME MSQSPTNAME CHAR35 CHAR 35   0   Lock request mode translated from table sptvalue.  
4 KPID MSQTHREDID INT2 INT2 5   0   Windows operating system thread ID  
5 BLOCKEDBY MSQBLOPRID INT2 INT2 5   0   SPID of blocking process.  
6 LOCKRSC MSQRSCTXT CHAR32 CHAR 32   0   Textual description of a lock resource from syslockinfo.  
7 DBNAME MSQDBNAME CHAR255 CHAR 255   0   The name of the database in SQL Server instance.  
8 LCKTYPE MSQLCKRSC CHAR10 CHAR 10   0   Lock resource type as e. g. KEY or PAGE.  
9 RSCLCKBIN MSQRSCBIN MSQHEX16 RAW 16   0   MS SQL server - binary lock resource  
10 LCKVALBLK MSQRSCLKBK MSQHEX16 RAW 16   0   MS SQL server - lock value block.  
11 INDNAME MSQTABNAME CHAR256 CHAR 256   0   MS SQL server table or index name  
12 LCKSTATUS MSQSPTNAME CHAR35 CHAR 35   0   Lock request mode translated from table sptvalue.  
13 LCKREFCNT MSQLKRECNT INT2 INT2 5   0   MS SQL server - lock reference count  
14 LCKCARCNT MSQLKCRYCT INT2 INT2 5   0   MS SQL server - lock carry-over reference count  
15 LCKLFETIME MSQLKLFTIM INT4 INT4 10   0   MS SQL server - lock lifetime bitmap.  
16 ECID MSQECID INT4 INT4 10   0   Execution context ID used to uniquely identify subthreads  
17 LCKOWNER MSQLCKOWN INT2 INT2 5   0   MS SQL server - type of object associated with a lock  
18 PROSSTAT MSQPRSTAT CHAR60 CHAR 60   0   SQL Server process status; ie sleeping, running etc.  
19 PROSUSER MSQUSRNAME CHAR128 CHAR 128   0   The user name used to log into the SQL Server database  
20 HOSTNAME MSQHOSTNAM CHAR256 CHAR 256   0   Hostname of the application server logged into SQL Server.  
21 PROGNAME MSQAPPPROG CHAR256 CHAR 256   0   Name of the application program which owns the connection.  
22 WAITTYPE MSQWAITTYP INT2 INT2 5   0   Wait type of waiting process, reserved field of sysprocesses  
23 EXECCMD MSQEXECMD CHAR32 CHAR 32   0   Command currently being executed by the given process id  
24 HOSTPROS MSQWKPROID CHAR16 CHAR 16   0   The application program's process ID on the given host  
History
Last changed by/on SAP  20130604 
SAP Release Created in