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

Dropping Old Indexes and Creating New Indexes

Perform the following procedure to drop old schema indexes and create new schema indexes.

To drop old index schemas and create new index schemas

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 option for the application you are upgrading.
   • For Siebel eBusiness application upgrades, select option 10: OLD SCHEMA DROP INDEX.
   • For Siebel Industry application (SIA) upgrades, select option 13: OLD SCHEMA DROP INDEX.

     This places you in edit mode for dataset DSNHLQ.SIEBEL.INSTALL.JCL(@GPDRPIX).

4. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(@GPDRPIX).

   NOTE:  After running this job, verify that it was successful by reviewing the sysout in SDSF and making sure the RC=0.

5. After submitting the job, enter cancel on the command line or press PF3 to save changes.
6. Verify that the JCLTEST return code is FLUSH (RC=0 or RC=4).

   Jobs with an ABEND (end abnormally) U99 or U099 message are jobs that failed.

   If you selected Siebel-Scheduled Mode, this job is logged (as Completed Successfully or Failed) to the target Siebel log table: TARGET_TABLEOWNER.TMP_SBLLOG_TAR.

   NOTE:  You must fix any failed jobs before proceeding with the upgrade. For information on restarting failed jobs, see Running the Siebel Upgrade Wizard.

   This job runs DDL to drop old-schema non-unique indexes.

7. After the ###DRPIX job has successfully completed, run the PRE-GEN PRIMARY INDEX DDL job.
8. Make sure you are at the Siebel Upgrade Job Submission Menu.
   • For Siebel eBusiness application upgrades, the panel ID is SBLRUNHP.
   • For Siebel Industry application (SIA) upgrades, the panel ID is SBLRUNFP.
9. Select the option for the application you are upgrading.
   • For Siebel eBusiness application upgrades, select option 11: PRE-GEN PRIMARY INDEX DDL.
   • For Siebel Industry application (SIA) upgrades, select option 14: PRE-GEN PRIMARY INDEX DDL.

     This places you in edit mode for dataset DSNHLQ.SIEBEL.INSTALL.JCL(@GPPREIX).

10. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(@GPPREIX).

    After the job is run, verify that the job ran successfully. (RC=0 or RC=4 indicates that the job was successful.)

    Jobs with an ABEND (end abnormally) U99 or U099 message are jobs that failed.

    If you selected Siebel-Scheduled Mode, this job is logged (as Completed Successfully or Failed) to the target Siebel log table: TARGET_TABLEOWNER.TMP_SBLLOG_TAR.

    NOTE:  You must fix any failed jobs before proceeding with the upgrade. For information on restarting failed jobs, see Running the Siebel Upgrade Wizard.

11. After submitting the job, enter cancel on the command line or press PF3 to save changes.
12. Verify that the JCLTEST return code is FLUSH (RC=0 or RC=4).

    Jobs with an ABEND (end abnormally) U99 or U099 message are jobs that failed.

    If you selected Siebel-Scheduled Mode, this job is logged (as Completed Successfully or Failed) to the target Siebel log table: TARGET_TABLEOWNER.TMP_SBLLOG_TAR.

    NOTE:  You must fix any failed jobs before proceeding with the upgrade. For information on restarting failed jobs, see Running the Siebel Upgrade Wizard.

    This job runs DDL to create new-schema non-unique indexes.