SAP ABAP Data Element QQAPR (iSeries: Reason Code for Access Plan Rebuild)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB4 (Application Component) DB2 for AS/400
⤷
STU4 (Package) CCMS / AS/400
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 | QQAPR |
| Short Description | iSeries: Reason Code for Access Plan Rebuild |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | QQC41 | |
| Data Type | CHAR | Character String |
| Length | 4 | |
| Decimal Places | 0 | |
| Output Length | 4 | |
| 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 | APlR |
| Medium | 21 | RC Acc. Plan Reb. |
| Long | 41 | RC for Access Plan Rebuild |
| Heading | 55 | RC for Access Plan Rebuild |
Documentation
Definition
QQAPR contains the reason code explaining why the database optimizer rebuilt the existing access plan if the access plan rebuild ocurred at the time of the most expensive execution of the statement.
Value range
- A1
- A file or member is not the same object as the one referenced when the access plan was last built.
Some reasons that they could be different are:
- Object was deleted and recreated
- Object was saved and restored
- Library list was changed
- Object was renamed
- Object was moved
- Object was overridden by a different object
- This is the first run of the query after the object containing
the query was restored - A2
- Access plan was built to use a reusable Open Data Path (ODP) and the optimizer chose to use a non-reusable ODP for this non-reusable ODP for this call.
- A3
- Access plan was built to use a non-reusable ODP and the optimizer chose to use a reusable ODP for this call.
- A4
- The number of records in the member has changed by more than 10% since the access plan was last built.
- A5
- A new access path exists over the member.
- A6
- An access path over the member that was used for this access plan no longer exists or is no longer valid.
- A7
- OS/400 query requires the access plan to be rebuilt because of system programming changes.
- A8
- The CCSID of the current job is different from the CCSID of the job that last created the access plan.
- A9
- The value of one or more of the following is different for the current job than it was for the job that last created this access plan:
- Date format
- Date separator
- Time format
- Time separator - AA
- The sort sequence table specified is different from the sort sequence table that was used when this access plan was created.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
