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

Creating 8.1 Schema Indexes

Perform the following procedure to drop old schema indexes, create 8.1 schema and EIM indexes, and submit the rebuild jobs for the 8.1 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 Migration "UPGISS" jobs completed. Re-enter option 9 to continue.

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

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

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. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
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. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
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. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
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. Review the output in SDSF or another job output facility. Verify that the return code is 0 or 4 and that the JCLTEST return code is FLUSH. If you do not see the FLUSH return code, you can verify the condition codes by searching for the condition code IEF206I.
18. After submitting the job, press PF3 to return to the Target Database In-Place Upgrade Menu.