SAP ABAP Table MSQLOCKINF (MS sql server lock info information for blockers and waiters)
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 MSQLOCKINF   Table Relationship Diagram
Short Description MS sql server lock info information for blockers and waiters    
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 MSQSERPRID INT4 INT4 10   0   SQL Server process ID  
2 KPID MSQTHREDID INT2 INT2 5   0   Windows operating system thread ID  
3 STATUS MSQPRSTAT CHAR60 CHAR 60   0   SQL Server process status; ie sleeping, running etc.  
4 USERNAME MSQUSRNAME CHAR128 CHAR 128   0   The user name used to log into the SQL Server database  
5 HOSTNAME MSQHOSTNE CHAR128 CHAR 128   0   Hostname of the application server logged into SQL Server.  
6 PROGNAME MSQPRONE CHAR128 CHAR 128   0   Name of the application program which owns the connection.  
7 HOSTPID MSQWKPROID CHAR16 CHAR 16   0   The application program's process ID on the given host  
8 EXECCMD MSQEXECMD CHAR32 CHAR 32   0   Command currently being executed by the given process id  
9 BLOCKED MSQBLOPRID INT2 INT2 5   0   SPID of blocking process.  
10 WAITTYPE MSQWAITTYP INT2 INT2 5   0   Wait type of waiting process, reserved field of sysprocesses  
11 WAITTIME MSQWAITIME INT4 INT4 10   0   Current wait time of the process in milliseconds  
12 BINLOCK MSQRSCBIN MSQHEX16 RAW 16   0   MS SQL server - binary lock resource  
13 LCKVALBLK MSQRSCLKBK MSQHEX16 RAW 16   0   MS SQL server - lock value block.  
14 INDNAME MSSOBJECT MSSSYSNAME CHAR 128   0   Object name  
15 LCKSTATUS MSQLCKSTAT INT2 INT2 5   0   MS SQL server - Lock request status  
16 LCKREFCNT MSQLKRECNT INT2 INT2 5   0   MS SQL server - lock reference count  
17 LCKCARCNT MSQLKCRYCT INT2 INT2 5   0   MS SQL server - lock carry-over reference count  
18 LCKLFETIME MSQLKLFTIM INT4 INT4 10   0   MS SQL server - lock lifetime bitmap.  
19 ECID MSQECID INT4 INT4 10   0   Execution context ID used to uniquely identify subthreads  
20 LCKOWNERTY MSQLCKOWN INT2 INT2 5   0   MS SQL server - type of object associated with a lock  
21 DBASENAME MSSDB MSSSYSNAME CHAR 128   0   Database name  
22 OBJNAME MSSOBJECT MSSSYSNAME CHAR 128   0   Object name  
23 LOCKRES MSQRSCTXT CHAR32 CHAR 32   0   Textual description of a lock resource from syslockinfo.  
24 LOCKTYPE MSQLCKRSC CHAR10 CHAR 10   0   Lock resource type as e. g. KEY or PAGE.  
25 LOCKNAME MSQSPTNAME CHAR35 CHAR 35   0   Lock request mode translated from table sptvalue.  
History
Last changed by/on SAP  20130604 
SAP Release Created in