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
- Make sure you are at the Siebel Upgrade Job Submission Menu for your upgrade path.
The Panel ID is SBLRUNFP.
- 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).
- Press Enter to start generating RUNSTATS jobs.
- 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.
|