Siebel Database Upgrade Guide for DB2 for z/OS > Generating the Siebel Upgrade Files >

Process of Generating the Upgrade Files

Upgrades: All upgrades.

Environments: All environments.

When the staging database has been created, you run the Database Configuration Wizard to generate the upgrade files. This process involves the following tasks:

1. Complete the tasks described in Required Tasks for Generating the Upgrade Files.
2. Restart the upgrade process from the midtier to generate upgrade files. See Restarting the Siebel Upgrade Wizard After Pauses for further information. The Upgrade Wizard stops at Pause #1.
3. Transfer the files generated up to Pause #1 to the z/OS host and apply them. See Preparing the Additive Schema and JCL Files on the z/OS Host.
4. (Production environment only) If you are upgrading a production database, you can optionally choose to apply the additive schema changes to the staging database. See Applying the Additive Schema Changes to the Production Staging Database for further information.
5. Restart the Upgrade wizard as described in Restarting the Siebel Upgrade Wizard After Pauses. After generating further files, the Upgrade Wizard stops at Pause #2.
6. Transfer the files generated up to Pause #2 to the z/OS host and run the jobs against the staging database. See Preparing and Executing the Nonadditive Schema and JCL Files on the z/OS Host.
7. Return to the midtier and restart the Upgrade wizard as described in Restarting the Siebel Upgrade Wizard After Pauses. The Upgrade Wizard generates the SCINDX.SQL file on the midtier and stops at Pause #3.
8. Transfer the SCINDX.SQL file to the z/OS host and apply it to drop old schema indexes and create new 8.1 schema indexes. See Processing the Index Schema File.
9. Build the JCL Templates that will be used to upgrade the target database. See Building JCL Templates for the Target Database for further information.

This completes the File Generation Process.