SAP ABAP Data Element DB2RUNFDTS (Table 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 DB2RUNFDTS
Short Description Table definition for RUNSTATS TABLESPACE statement  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type DB2RUNFDTS    
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 Table def. 
Medium 20 Table definitions 
Long 40 Table definitions for RUNSTATS TS 
Heading 0   
Documentation

Definition

For the RUNSTATS TABLESPACE you can specify the following parameters:

  • TABLE
  • SAMPLE
  • COLUMN

The parameters are separated by a comma.

Syntax: TABLE <tablename>,SAMPLE <samplenumber>,COLUMN <columnnumber>,TABLE <tablename>

The parameters listed above have the following syntax:

  • TABLE
    • Description: Specifies the table for which column information is to be gathered. All tables must belong to the specified tablespace.
    • Syntax: TABLE <tablename>
    • Comment: You can specify TABLE with a table name or with the value ALL. TABLE ALL can only be followed by SAMPLE .
  • SAMPLE
    • Description: Indicates the percentage of rows to sample when collecting non-indexes column statistics.
    • Syntax: SAMPLE <samplenumber>
    • Comment: Any value from 1 through 100 can be specified.
  • COLUMN
    • Description: Specifies columns for which information is to be gathered.
    • Syntax: COLUMN <columnname>
    • Comment: You can only specify COLUMN if you have specified a table name beforehand.

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

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