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

1. If you are not on the Siebel Upgrade Main Menu, enter the following command:

   TSO SBLUPG77

2. 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.
3. 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).
4. To start generating RUNSTATS jobs, press Enter.