SAP ABAP Data Element DB2RUNFDIX (Index definition for RUNSTATS TABLESPACE statement)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Data Element DB2RUNFDIX
Short Description Index definition for RUNSTATS TABLESPACE statement  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type DB2RUNFDIX    
Data Type CHAR   Character String 
Length 80    
Decimal Places 0    
Output Length 80    
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 Index def. 
Medium 20 Index definition 
Long 40 Index definition for RUNSTATS TABLESPACE 
Heading 0   
Documentation

Definition

For the RUNSTATS TABLESPACE statement you can specify the following parameters:

  • INDEX
  • PART
  • KEYCARD
  • NUMCOLS
  • COUNT

The parameters are separated by a comma.

Syntax: INDEX <indexname>,PART <partnumber>,KEYCARD,NUMCOLS<numcolsnumber>,COUNT <countnumber>

The parameters listed above have the following syntax:

  • INDEX
    • Description: Specifies indexes for which information is to be gathered. Column information is gathered for the first column of the index. Non-uniform distribution statistics are collected for all indexes in the list except for those whose distribution are uniform. All the indexes must be associated with the same tablespace, which must be the specified tablespace.
    • Syntax: INDEX <indexname>
  • PART
    • Desciption: Identifies an index partition for which statistics are to be collected.
    • Syntax: PART <partitionnumber>
    • Comment: You can only specify this parameter when INDEX is followed by an index name.
  • KEYCARD
    • Desription: Collects all of the distinct values in all of the 1 to n key column combinations for the specified indexes. n is the number of columns in the index.
    • Syntax: KEYCARD
    • Comment: KEYCARD has no input value.
  • NUMCOLS
    • Description:Indicates the number of key columns to concatenate together when collecting frequent values from the specified index.
    • Syntax: NUMCOLS <numcolsnumber>
    • Comment: NUMCOLS can only be followed by COUNT.
  • COUNT
    • Description: Indicates the number of frequent values to be collected.
    • Syntax: COUNT <countnumber>
    • Example: Specifying '15' means 15 frequent values from the specified key columns are collected.

If you specify INDEX ALL, all other indexes are ignored in the generated utility statement preview. Only INDEX ALL is executed.

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