Setting RUNSTATS column statistics

The Runstats Utility Column Statistics panel allows you to set column statistics that will be collected during RUNSTATS.

1. To specify statistics, enter Y in the Update statistics field on the Runstats Options panel.
   When you press Enter, the panel that is shown in the following figure is displayed.

    AUTOXPRT V1R1 ---- RUNSTATS Utility Column Statistics --- 2023/10/20  12:53:34 
    Option  ===>                                                  Scroll ===> CSR  
    Line Commands: V - View  C - Create  D - Delete  U - Update                    
    -------------------------------------------------------------------------------
      Creator: TWUSR      Name: DB2 V13                             User: TWUSR    
                                                           Db2 Subsystem: SS01     
                                                          Row 1 of 1               
    -------------------------------------------------------------------------------
    Cmd  Statistic Definition                                                      
     C   Press Enter to Create Statistics                                          
    ***************************** Bottom of Data **********************************
                                                                                   

   This panel allows you to view and set statistics that will be collected.
2. To set a column statistic definition, enter C in the line command area and press Enter.
   The Runstats Column Statistics Create window is displayed.
3. Enter Y next to the type of statistics (FREQVAL or HISTOGRAM) that you want to define and press Enter.
4. Set FREQVAL options on the Freqval Options window.
   Refer to the help panel for information about the fields on this panel.
5. Set HISTOGRAM options as follows on the Histogram Options window.
   Refer to the help panel for information about the fields on this panel.