Migration Information › Run the RUNSTATS Utility

Run the RUNSTATS Utility

At this point you must update the catalog statistics of the CA Repository DB2 tables using the DB2 utility RUNSTATS. The statistics are used to calculate the size of the unload data sets in the Create the New Tables and Resynchronize Existing Tables. These statistics are run against the tables for all products you selected in Define Installation Defaults.

To run RUNSTATS

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

   --------- Installation - 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 values are entered in all the fields, press Enter. The JCL for running RUNSTATS appears.
4. Check the generated JCL before submission and correct any system conflicts.
5. Submit the job and review the results a RC of 4 is expected.
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 need to create the utility JCL by hand.

   For more information about these utilities see the appropriate IBM DB2 for z/OS Utilities Guide.