Bookshelf Home | Contents | Index | PDF     

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

Rebuilding the Gen Primary 7.8 Indexes

Perform the following task to submit the rebuild jobs for the 7.8 Gen Primary indexes.

To rebuild a primary index

  1. Make sure you are at the Siebel Upgrade Job Submission Menu for your upgrade path.
    • For Siebel Business application upgrades, the panel ID is SBLRUNHP.
    • For Siebel Industry application (SIA) upgrades, the panel ID is SBLRUNFP.
  2. Select the option for the application you are upgrading.
    • For Siebel Business application upgrades, select option 12: PRE-GEN PRIMARY INDEX REBUILDS.
    • For Siebel Industry application (SIA) upgrades, select option 15: PRE-GEN PRIMARY INDEX REBUILDS.

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

  3. Run the job using the JCL in dataset DSNHLQ.SIEBEL.INSTALL.JCL(SUBGPREX).

    Verify that the job ran successfully (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 Restarting Failed Jobs on the Mainframe.

  4. After submitting the job, enter cancel on the command line or press PF3 to save changes.

    This submits 2000+ Index Rebuild jobs. The number of Index Rebuild jobs varies by upgrade type. Job names range from ###10001 to ###1nnnn.

    
Upgrade Guide for DB2 UDB for z/OS