Table/Structure Field list used by SAP ABAP Function Module DB_MSS_EXCLUSIVE_LOCK_WAITERS (MS SQL Server exclusive lock waiters)
SAP ABAP Function Module
DB_MSS_EXCLUSIVE_LOCK_WAITERS (MS SQL Server exclusive lock waiters) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | EXCLLCKWTS - HOLDER_PID | PID of an ABAP WP (DB Session) | ||
| 2 | EXCLLCKWTS - HOLDER_SID | SID of a DB session | ||
| 3 | EXCLLCKWTS - H_HOSTNAME | Application Server | ||
| 4 | EXCLLCKWTS - LOCK_LEVEL | DB lock step (1 = holder does not wait for other locks) | ||
| 5 | EXCLLCKWTS - OBJ_NAME | Object: Name of table or index | ||
| 6 | EXCLLCKWTS - WAITER_PID | PID of an ABAP WP (DB Session) | ||
| 7 | EXCLLCKWTS - WAITER_SID | SID of a DB session | ||
| 8 | EXCLLCKWTS - WAITSSINCE | Number of seconds waiting for a DB lock | ||
| 9 | EXCLLCKWTS - W_HOSTNAME | Application Server | ||
| 10 | MSSDBLOCKS - HOLDSPID | MS SQL Server process ID (blocking) | ||
| 11 | MSSDBLOCKS - HOSTNAME | Hostname of the application server logged into SQL Server | ||
| 12 | MSSDBLOCKS - OBJNAME | Table name | ||
| 13 | MSSDBLOCKS - REQPID | MS SQL-Server host process id (= OS work process ID) | ||
| 14 | MSSDBLOCKS - REQSPID | MS SQL Server process ID | ||
| 15 | MSSDBLOCKS - WAITTIME | Current wait time of the process in milliseconds | ||
| 16 | SYST - DBSYS | ABAP System Field: Central Database System |