Data Element list used by SAP ABAP Table MSQLOCKINF (MS sql server lock info information for blockers and waiters)
SAP ABAP Table MSQLOCKINF (MS sql server lock info information for blockers and waiters) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | MSQBLOPRID | SPID of blocking process. | |
2 | Data Element | MSQECID | Execution context ID used to uniquely identify subthreads | |
3 | Data Element | MSQEXECMD | Command currently being executed by the given process id | |
4 | Data Element | MSQHOSTNE | Hostname of the application server logged into SQL Server. | |
5 | Data Element | MSQLCKOWN | MS SQL server - type of object associated with a lock | |
6 | Data Element | MSQLCKRSC | Lock resource type as e. g. KEY or PAGE. | |
7 | Data Element | MSQLCKSTAT | MS SQL server - Lock request status | |
8 | Data Element | MSQLKCRYCT | MS SQL server - lock carry-over reference count | |
9 | Data Element | MSQLKLFTIM | MS SQL server - lock lifetime bitmap. | |
10 | Data Element | MSQLKRECNT | MS SQL server - lock reference count | |
11 | Data Element | MSQPRONE | Name of the application program which owns the connection. | |
12 | Data Element | MSQPRSTAT | SQL Server process status; ie sleeping, running etc. | |
13 | Data Element | MSQRSCBIN | MS SQL server - binary lock resource | |
14 | Data Element | MSQRSCLKBK | MS SQL server - lock value block. | |
15 | Data Element | MSQRSCTXT | Textual description of a lock resource from syslockinfo. | |
16 | Data Element | MSQSERPRID | SQL Server process ID | |
17 | Data Element | MSQSPTNAME | Lock request mode translated from table sptvalue. | |
18 | Data Element | MSQTHREDID | Windows operating system thread ID | |
19 | Data Element | MSQUSRNAME | The user name used to log into the SQL Server database | |
20 | Data Element | MSQWAITIME | Current wait time of the process in milliseconds | |
21 | Data Element | MSQWAITTYP | Wait type of waiting process, reserved field of sysprocesses | |
22 | Data Element | MSQWKPROID | The application program's process ID on the given host | |
23 | Data Element | MSSDB | Database name | |
24 | Data Element | MSSOBJECT | Object name | |
25 | Data Element | MSSOBJECT | Object name |