Siebel Database Upgrade Guide for DB2 for z/OS > Upgrading the Target Database > Performing the In-Place Target Database Upgrade >

Generating RUNSTATS Jobs

Upgrades: All upgrades.

Environments: All environments.

The following procedure generates RUNSTATS jobs for all Siebel table spaces. This process excludes all interface tables (EIM and tables with an _IF suffix).

NOTE:  If you are performing a development environment upgrade, run the RUNSTATS jobs before starting the repository merge process.

To generate RUNSTATS jobs

1. On the Target Database In-Place Upgrade Menu, select option 11: Generate/Run Runstats, and press Enter.

   The following message appears:

   Before proceeding, make sure ALL "Gen-Primary" jobs completed. Re-enter option 11 to continue.

2. Reselect option 11: Generate/Run Runstats, and press Enter.

   The Upgrade Runstats panel appears. The panel ID is SBLRSP.

3. Read the information relating to the RUNSTATS jobs on the Upgrade Runstats panel, then press Enter to start the RUNSTATS job generation process.
4. Messages are displayed as the jobs are generated. When the process is completed, press Enter.

   You are placed in edit mode on the PDS data set that contains the RUNSTATS jobs, DSNHLQ.SIEBEL.RUNST.

5. Select the DSNHLQ.SIEBEL.RUNST(@RSTXREF) PDS member.

   This file contains information relating to each RUNSTATS job, for example, the table for which the job collects statistics and when statistics were last collected on the table.

6. Select the RUNSTATS jobs you want to run and run each one individually using the JCL in the data set DSNHLQ.SIEBEL.RUNST(@RSTXREF).

   Alternatively, go to the DSNHLQ.SIEBEL.INSTALL.JCL(SUBRUNST) data set and submit the JCL in the data set to run all the RUNSTATS jobs for table spaces that did not have statistics collected during any of the previous upgrade processes.

7. Verify that the job(s) ran successfully. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
8. Press PF3 to save changes.