Executing Index DDL and Rebuilding Indexes

Perform the following procedure to execute the index DDL for Siebel CRM, and to rebuild indexes on the target database.

To execute the index DDL and to rebuild indexes

1. On the Target Database Non-Additive Processes menu, select option 4: Create Restructured Indexes (DDL), and press Enter.

   The following message appears:

   Before proceeding, make sure ALL “LOAD jobs completed. Re-enter option 4 to 
   continue.
   

2. Reselect option 4: Create Restructured Indexes (DDL), and press Enter.

3. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(SCHEMAT2).

   This job runs DDL Create Index statements to build nonunique indexes for the old schema.

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

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

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

7. Run the job using the JCL in data set DSNHLQ.SIEBEL.INSTALL.JCL(SUBNONIX).

   This job automatically submits all nonunique 8.1 and 8.2 index rebuild jobs.

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

   You must fix any failed jobs before proceeding with the upgrade. For information on restarting failed jobs, see Restarting Upgrade Jobs That Fail.