SAP ABAP Data Element DB2T3DURAT (Duration of a lock)
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 | DB2T3DURAT |
| Short Description | Duration of a lock |
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 | Duration |
| Medium | 15 | Duration |
| Long | 20 | Duration |
| Heading | 16 | Duration |
Documentation
Definition
The duration of a lock. This field can show one of the following values:
MANUAL
DB2 releases the lock manually (for example, cursor stability).
MANUAL+1
Temporary change of consistency level from CS to RR during Bind and DDL.
COMMIT
The lock is released during commit.
COMMIT+1
The locks needed to maintain the position for a cursor opened WITH HOLD are held past commit.
ALLOC
The lock is acquired when the resource is allocated and is released when the resource is deallocated.
PLAN
The lock is released when the plan is deallocated.
UTILITY
The lock is released when the utility processing completes.
If a lock duration is classified as serviceability by DB2 or the lock duration is unknown, the hexadecimal value of the lock duration is displayed.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 710 |
