SAP ABAP Data Element MSSBLOCKED (MS SQL Server sp ID of blocking process)
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
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
| Data Element | MSSBLOCKED |
| Short Description | MS SQL Server sp ID of blocking process |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | INT2 | |
| Data Type | INT2 | 2-byte integer, only for length field before LCHR or LRAW |
| Length | 5 | |
| Decimal Places | 0 | |
| Output Length | 5 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | blockerpid |
| Medium | 15 | blocking sp ID |
| Long | 20 | SQL blocking sp ID |
| Heading | 30 | MS SQL-Server blocking sp ID |
Documentation
Definition
The given SQL Server process is shown as the one blocking the given
process. This process may itself be blocked by another one, and so on.
The lock that is the original cause of the blocking situation may be any
shown blocking lock object in the process tree above.
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
