Siebel Database Upgrade Guide for DB2 for z/OS > Generating the Siebel Upgrade Files > Processing the Index Schema File >

Restructuring the Index DDL

Perform the following procedure to prepare the Index JCL.

To restructure the index DDL

1. Go to the Siebel In-Place Upgrade Main Menu by entering the following command, and pressing Enter:

   TSO SBLUPG81

2. On the Siebel In-Place Upgrade Main Menu, select option 1: File Generation, and press Enter. The Staging Database File Generation Menu is displayed.
3. On the Staging Database File Generation Menu, select option 6: Process SCINDX Index Components - Restructure Indexes, and press Enter.

   A message appears, asking you to confirm that the DSNHLQ.SIEBEL.PROC(ISPBAT) (ISPF batch proc) is correctly configured.

   You can choose to generate index rebuilds in either TSO foreground mode or batch mode. It is recommended that you perform the procedure in batch mode.

4. Enter Y to confirm that the ISPF batch proc is correctly configured, and press Enter.
5. When the following message appears, specify the number of indexes to be included in each rebuild job, and press Enter:

   NUMBER OF INDEXES PER REBUILD JOB.

   The maximum number of indexes that can be included in a job is 10. It is recommended that you specify 3.

   CAUTION:  Consider your objective before choosing a maximum number of indexes for each job. Increasing this number results in fewer jobs but requires more memory and sort work. Reducing this number results in more jobs, which reduces resource requirements but results in fewer indexes being built in parallel.

6. Press Enter, and you are placed in Edit mode in the DSNHLQ.SIEBEL.INSTALL(SBLJCL31) data set.
7. Submit the job and 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.

8. Press PF3 twice to return to the Staging Database File Generation Menu.