SAP ABAP Data Element QQAPRT (iSeries: Timestamp of Access Plan Rebuild (Database Monitor))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB4 (Application Component) DB2 for AS/400
⤷
STU4 (Package) CCMS / AS/400

⤷

⤷

Basic Data
Data Element | QQAPRT |
Short Description | iSeries: Timestamp of Access Plan Rebuild (Database Monitor) |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | QQTIME | |
Data Type | CHAR | Character String |
Length | 26 | |
Decimal Places | 0 | |
Output Length | 26 | |
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 | 11 | Acc. Reb. |
Medium | 21 | Acc. Reb. Timestamp |
Long | 41 | Acc. Plan Rebuild Time |
Heading | 55 | Acc. Plan Rebuild Time |
Documentation
Definition
QQAPRT is the timestamp of the last time the access plan for a statement was rebuilt by the database optimizer.
Note
The current access plan of a statement is saved in the SQL package.
The database optimizer rebuilds an existing access plan if, for example:
- A previously used access path (index) was deleted
- A new index was created that improves the statement execution
- If the number of records in the table has changed too much since the last time the access plan was built
The reason for the access plan rebuild is described in QQAPRT.
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in |