Migration Information › Run the RUNSTATS Utility

Run the RUNSTATS Utility

At this point you must update the CA Repository for z/OS DB2 table catalog statistics using the DB2 utility, RUNSTATS. The statistics are used to calculate the size of the unload data sets in the next step Bind All Plans and Packages.

To run the RUNSTATS against the tables for all products you selected for installation in Define Installation Defaults

1. At the Installation Customization Menu, select option 12 DB2 Utilities. The Run DB2 Utilities screen displays.

   ---------  Run DB2 Utilities -------------------------
    COMMAND ===>                                                                   
                                                                                   
    Execute Utilities                                                              
                                                                                   
               Utility? ===> RUNSTAT (RUNSTAT,REORG,ALTER)                         
        Edit or Submit? ===> E (E-edit,S-submit)                                   
           Save Output? ===> N (Y-yes,N-no)                                        
        Output Data Set ===>                                                       
                                                                                   
    Enter ENTER command to continue or END command to EXIT
   

2. Enter values into the fields as follows:
   • Utility

     Specify RUNSTAT.

   • Edit or Submit

     Specify E.

   • Save Output

     Specify Y to save the generated JCL in the data set specified in Output Data Set.

     Specify N to discard the JCL after running the job.

   • Output Data Set

     The fully qualified name (without quotation marks) of the partitioned data set you want to use to save the JCL that this step generates. Ensure that you change the names if you do not want to overwrite any previously saved JCL.

3. Once you have entered values in all the fields, press Enter. JCL for running RUNSTATS appears.
4. Check the generated JCL before submission and correct any system conflicts.
5. Submit the job.
6. Use the END command or press PF3 to redisplay the Installation Customization Menu.

   Note: The DB2 Utilities screen performs the RUNSTATS and REORG utilities only on tables created in the databases listed in your DB2 Defaults (see Define DB2 Defaults). If extended entity tables are in different databases, you have to create the utility JCL by hand.