SAP Table MSQLOCKINF
MS sql server lock info information for blockers and waiters
MSQLOCKINF (MS sql server lock info information for blockers and waiters) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MSQLOCKINF to other SAP tables.
MSQLOCKINF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| SPID | SQL Server process ID | MSQSERPRID | INT4 | 10 | 0 | |||
| KPID | Windows operating system thread ID | MSQTHREDID | INT2 | 5 | 0 | |||
| STATUS | SQL Server process status; ie sleeping, running etc. | MSQPRSTAT | CHAR | 60 | 0 | |||
| USERNAME | The user name used to log into the SQL Server database | MSQUSRNAME | CHAR | 128 | 0 | |||
| HOSTNAME | Hostname of the application server logged into SQL Server. | MSQHOSTNE | CHAR | 128 | 0 | |||
| PROGNAME | Name of the application program which owns the connection. | MSQPRONE | CHAR | 128 | 0 | |||
| HOSTPID | The application program's process ID on the given host | MSQWKPROID | CHAR | 16 | 0 | |||
| EXECCMD | Command currently being executed by the given process id | MSQEXECMD | CHAR | 32 | 0 | |||
| BLOCKED | SPID of blocking process. | MSQBLOPRID | INT2 | 5 | 0 | |||
| WAITTYPE | Wait type of waiting process, reserved field of sysprocesses | MSQWAITTYP | INT2 | 5 | 0 | |||
| WAITTIME | Current wait time of the process in milliseconds | MSQWAITIME | INT4 | 10 | 0 | |||
| BINLOCK | MS SQL server - binary lock resource | MSQRSCBIN | RAW | 16 | 0 | |||
| LCKVALBLK | MS SQL server - lock value block. | MSQRSCLKBK | RAW | 16 | 0 | |||
| INDNAME | Object name | MSSOBJECT | CHAR | 128 | 0 | |||
| LCKSTATUS | MS SQL server - Lock request status | MSQLCKSTAT | INT2 | 5 | 0 | |||
| LCKREFCNT | MS SQL server - lock reference count | MSQLKRECNT | INT2 | 5 | 0 | |||
| LCKCARCNT | MS SQL server - lock carry-over reference count | MSQLKCRYCT | INT2 | 5 | 0 | |||
| LCKLFETIME | MS SQL server - lock lifetime bitmap. | MSQLKLFTIM | INT4 | 10 | 0 | |||
| ECID | Execution context ID used to uniquely identify subthreads | MSQECID | INT4 | 10 | 0 | |||
| LCKOWNERTY | MS SQL server - type of object associated with a lock | MSQLCKOWN | INT2 | 5 | 0 | |||
| DBASENAME | Database name | MSSDB | CHAR | 128 | 0 | |||
| OBJNAME | Object name | MSSOBJECT | CHAR | 128 | 0 | |||
| LOCKRES | Textual description of a lock resource from syslockinfo. | MSQRSCTXT | CHAR | 32 | 0 | |||
| LOCKTYPE | Lock resource type as e. g. KEY or PAGE. | MSQLCKRSC | CHAR | 10 | 0 | |||
| LOCKNAME | Lock request mode translated from table sptvalue. | MSQSPTNAME | CHAR | 35 | 0 | |||
