Upgrade Guide for DB2 UDB for z/OS and OS/390 > Upgrading a Database from the Mainframe >
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
- If you are not on the Siebel Upgrade Main Menu, enter the following command:
TSO SBLUPG77
- Select option 4: UPGRADE - RUN UPGRADE/POST-UPGRADE MAINTENANCE.
The Siebel Upgrade Job Submission Menu appears.
- For Siebel eBusiness application upgrades, the panel ID is SBLRUNHP.
- For Siebel Industry application (SIA) upgrades, the panel ID is SBLRUNFP.
- Select the appropriate menu option for your upgrade path for intersection table maintenance:
- For Siebel eBusiness application upgrades, select option 17: RUNSTATS (SCHEMA W/O STATS).
- For Siebel Industry application upgrades, selection option 20: RUNSTATS (SCHEMA W/O STATS).
- To start generating RUNSTATS jobs, press Enter.
|