SAP ABAP Data Element QQIRSN (iSeries: Index Reason Code (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 QQIRSN
Short Description iSeries: Index Reason Code (Database Monitor)  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type QQC301    
Data Type CHAR   Character String 
Length 30    
Decimal Places 0    
Output Length 30    
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 Idx.Reason 
Medium 21 Idx. Reason Code 
Long 41 Index Reason Code 
Heading 55 Index Reason Code 
Documentation

Definition

QQIRSN is the list of reason codes the optimizer used when considering the access paths of a table used in a statement.
The list of considered indexes and the reason code explaining their rejection is contained in QQIDXN.

History
Last changed by/on SAP  20070813 
SAP Release Created in