Siebel Database Upgrade Guide for DB2 for z/OS > Upgrading the Target Database > Performing the In-Place Target Database Upgrade >

Creating Schema Indexes

Perform the following procedure to drop old schema indexes, create schema and EIM indexes for the current release, and submit the rebuild jobs for the 8.1 or 8.2 Gen Primary indexes for the target database.

To run index jobs for the target database

1. On the Target Database In-Place Upgrade Menu, select option 9: SCINDX Index Processes, and press Enter.

   The following message appears:

   Before proceeding, make sure ALL Data Migr "UPGISS" jobs complete. Re-enter option 9 to continue...

2. Reselect option 9: SCINDX Index Processes, and press Enter.

   The Target SCINDX Index Processes Menu is displayed. The panel ID is SBLSIXP.

   

   Figure 13. Target SCINDX Index Processes Menu

3. Select option 0: Drop Old Schema Indexes, and press Enter.

   You are placed in edit mode on data set DSNHLQ.SIEBEL.INSTALL.JCL(GPDRPIX).

4. Submit the JCL in the data set to drop the old schema indexes.
5. Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.
6. After submitting the job, enter cancel on the command line or press PF3 to save changes.
7. On the Target SCINDX Index Processes Menu, select option 1: Create Pre-Gen Primary Indexes (DDL), and press Enter.

   You are placed in edit mode on data set DSNHLQ.SIEBEL.INSTALL.JCL(GPRIX).

8. Submit the JCL in the data set to run the DDL to create the Pre-Gen Primary Indexes.
9. Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.
10. After submitting the job, enter cancel on the command line or press PF3 to save changes.
11. On the Target SCINDX Index Processes Menu, select option 2: Rebuild Pre-Gen Primary Indexes (DDL), and press Enter. This job rebuilds the Pre-Gen primary indexes to create ROW_IDs for the data in the existing row.

    You are placed in edit mode on data set DSNHLQ.SIEBEL.INSTALL.JCL(SUBGPPIX).

12. Submit the JCL in the data set.

    This job runs all the Pre-Gen Primary Index rebuild jobs in parallel. The number of index rebuild jobs that are run varies according to your upgrade path and the number of indexes you specified to be included in each rebuild job. See Restructuring the Index DDL for further information.

13. Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.
14. After submitting the job, enter cancel on the command line or press PF3 to save changes.
15. On the Target SCINDX Index Processes Menu, select option 3: Create EIM Indexes (DDL), and press Enter.

    You are placed in edit mode on data set DSNHLQ.SIEBEL.INSTALL.JCL(EIMIX).

16. Submit the JCL in the data set to run the DDL to create new EIM indexes.
17. Verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.
18. After submitting the job, press PF3 to return to the Target Database In-Place Upgrade Menu.