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) >

Creating New EIM Indexes

Perform the following procedure to create the new EIM indexes.

NOTE:  This topic applies to Siebel Industry applications upgrades.

To create a new EIM index

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 16: EIM INDEX DDL.
   • For Siebel Industry application (SIA) upgrades, select option 19: EIM INDEX DDL.

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

4. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(@EIMIX).
5. Verify that the job ran successfully.

   RC=0 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.

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

   This job runs DDL to Create New-Schema (Siebel 7.7) EIM Indexes (Unique and Non-Unique).