SAP ABAP Data Element DB2TLKLA (Lock/latch supension time)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU3 (Package) Development Class for Database Monitor
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU3 (Package) Development Class for Database Monitor
Basic Data
| Data Element | DB2TLKLA |
| Short Description | Lock/latch supension time |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2CHAR16 | |
| Data Type | CHAR | Character String |
| Length | 16 | |
| Decimal Places | 0 | |
| Output Length | 16 | |
| 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 | Lock/Latch |
| Medium | 15 | Lock/Latch susp |
| Long | 20 | Lock/latch susp time |
| Heading | 0 |
Documentation
Definition
The accumulated lock and latch elapsed time. It indicates the elapsed time the allied agent waited for locks and latches in DB2. This value does not include suspensions due to group-level lock contentions in a data sharing environment. When the event completes, the ending time is used calculate the total elapsed wait time. The result is added to the previously saved lock and latch wait time in DB2.
If the suspension time is high, examine the Locking Activity window in thread activity.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
