SAP ABAP Data Element QQRCOD (Reason code)
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 QQRCOD
Short Description Reason code  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type QQRCOD    
Data Type CHAR   Character String 
Length 2    
Decimal Places 0    
Output Length 2    
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 ReasonCode 
Medium 11 Reason code 
Long 11 Reason code 
Heading RC 
Documentation

Definition

For records with QQRID 3000, 3001, 3002, 3003, 3004, 3005 and 3006, QQRCOD specifies why the optimizer chose that method of implementing a query.

List of Reason Codes

QQRID = 3000: (arrival sequence used to implement query)
T1 - No indexes exist.
T2 - Indexes exist but none could be used.
T3 - Optimizer chose table scan over indexes.

QQRID = 3001: (Using Existing Index)
I1 - Record selection.
I2 - Ordering/grouping criteria.
I3 - Record selection and ordering/grouping criteria.

QQRID = 3002: (Temporary Index Created)
I1 - Record selection.
I2 - Ordering/grouping criteria.
I3 - Record selection and ordering/grouping criteria.

QQRID = 3003: (Query Sort)
F1 - Query contains grouping fields (GROUP BY) from more than one
file or contains grouping fields from a secondary file of a join
query that cannot be reordered.
F2 - Query contains ordering fields (ORDER BY) from more than one file
or contains ordering fields from a secondary file of a join query
that cannot be reordered.
F3 - The grouping and ordering fields are not compatible.
F4 - DISTINCT was specified for the query.
F5 - UNION was specified for the query.
F6 - Query had to be implemented using a sort.
Key length of more than 2000 bytes or more than 120 key fields
specified for ordering.
F7 - Query optimizer chose to use a sort rather than an access path
to order the results of the query.
F8 - Perform specified record selection to minimize I/O wait time.

QQRID = 3004: (Temporary File)
F1 - Query contains grouping fields (GROUP BY) from more than one
file, or contains grouping fields from a secondary file of a join
query that cannot be reordered.
F2 - Query contains ordering fields (ORDER BY) from more than one file,
or contains ordering fields from a secondary file of a join query
that cannot be reordered.
F3 - The grouping and ordering fields are not compatible.
F4 - DISTINCT was specified for the query.
F5 - UNION was specified for the query.
F6 - Query had to be implemented using a sort.
Key length of more than 2000 bytes or more than 120 key fields
specified for ordering.
F7 - Query optimizer chose to use a sort rather than an access path
to order the results of the query.
F8 - Perform specified record selection to minimize I/O wait time.
F9 - file is a Join Logical File and its join type does not match the
join type specified in the query.
FA - Format specified for the logical file references more than one
physical file.
FB - File is a complex SQL view requiring a temporary result file to
contain the result of the SQL view.

QQRID = 3005 (Locked Tables)
L1 - UNION with *ALL
L2 - DISTINCT with *ALL
L3 - No duplicate keys without *ALL
L4 - Temporary needed with *ALL
L5 - System file with *ALL
L6 - Order by > 2000 bytes
with *ALL
L7 - Temporary needed with *CS
L8 - System file with *CS
L9 - Unknown

QQRID = 3006 (Access Plan Rebuilt)
A1 - A file or member is not the same object as the one referenced when
the access plan was last built.
Some reasons that why they might be different:
- 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