1. Database Upgrade Guide for DB2 for z/OS
  2. Creating and Rebuilding Obsolete Indexes

Creating and Rebuilding Obsolete Indexes

If you choose, you can create and rebuild the old schema obsolete indexes. This step is optional.

The procedure to create and rebuild obsolete indexes differs, depending on whether you perform this task during the target database upgrade process, or after you have completed the target database upgrade (recommended). Both procedures are described in this topic.

Perform the following procedure to create and rebuild obsolete indexes on the target database during the target database upgrade process.

To create and rebuild obsolete indexes during the database upgrade

  1. On the Target Database Non-Additive Processes menu, select option 6: Create Obsolete Indexes, and press Enter.

  2. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(SCHEMATO).

    This job automatically builds the old-schema obsolete indexes.

  3. Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.

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

  5. On the Target Database Non-Additive Processes menu, select option 7:Rebuild Obsolete Indexes, and press Enter.

  6. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(SUBOBSIX).

    This job automatically rebuilds the old-schema obsolete indexes.

  7. Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.

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

Perform the following procedure to create and rebuild obsolete indexes on the target database after the target database upgrade is completed.

To create and rebuild obsolete indexes after the database upgrade is completed

  1. To create the obsolete indexes, run the SQL in the DSNHLQ.SIEBEL.DDLOIND data set.

  2. Verify that the jobs ran successfully with a return code of 0. For information, see Verifying JCL Upgrade Jobs.

  3. Review the list of obsolete indexes created; rebuild only those indexes that you require.

  4. Rebuild the obsolete indexes by submitting the appropriate JCL in the DSNHLQ.SIEBEL.OBSIX.JCL data set.

    The control cards for the rebuild index jobs are located in the DSNHLQ.SIEBEL.OBSIX.SQL data set.

  5. Verify that the jobs ran successfully with a return code of 0. For information, see Verifying JCL Upgrade Jobs.