Upgrade Guide for DB2 UDB for z/OS > Upgrading a Database from the Mainframe > Executing the Upgrade on the z/OS Host (Phase 2 of 2) >

Generating RUNSTATS

Upgrades: All upgrades.

Environments: Development (mainframe-centric) environment and Production environment.

The following procedure generates RUNSTATS jobs for tablespaces that contain multiple-tables-per-tablespace or partitioned tablespaces and have not had statistics collected during any of the previous upgrade processes.

NOTE:  This process excludes all interface tables (EIM and tables with an _IF suffix).

To generate RUNSTATS jobs

1. Make sure you are at the Siebel Upgrade Job Submission Menu for your upgrade path.

   The Panel ID is SBLRUNFP.

2. Select the appropriate menu option for your upgrade path for intersection table maintenance:
   • For Siebel Business application upgrades, select option 15: RUNSTATS (SCHEMA W/O STATS).
   • For Siebel Industry application upgrades, selection option 18: RUNSTATS (SCHEMA W/O STATS).
3. Press Enter to start generating RUNSTATS jobs.
4. To start the generated RUNSTATS jobs, access the DSNHLQ.SIEBEL.INSTALL.JCL(SUBRUNST) member and start the ###SUBRS job.

   This will start the jobs listed in the DSNHLQ.SIEBEL.EXEC(@RST) member.

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