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. 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.

2. Enter Y to confirm that the ISPF batch proc is correctly configured, and press Enter.
3. 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.

4. Press Enter, and you are placed in Edit mode in the DSNHLQ.SIEBEL.INSTALL(SBLJCL31) data set.
5. Submit the job and verify that the job ran successfully with a return code of 0 or 4. For information, see Verifying JCL Upgrade Jobs.
6. Press PF3 twice to return to the Staging Database File Generation Menu.