1. Database Upgrade Guide for DB2 for z/OS
  2. Upgrade Siebel Database Schema (upgrep)

Upgrade Siebel Database Schema (upgrep)

  1. (Optional) Change the Siebel Database Configuration Wizard language. For information on this topic, see the chapter in Siebel Database Upgrade Guide that describes how to upgrade the Siebel database.

  2. Create the staging database by performing the following tasks:

    1. Required Tasks before Creating the Staging Database.

    2. Creating the Staging Database Schema DDL Files.

    3. Transferring the Staging DDL to the z/OS Host.

    4. Preparing the z/OS Upgrade Environment and Creating the Staging Database.

    5. Removing Interface Tables and Triggers.

  3. Generate the Upgrade Files by performing the following tasks:

    Note: Edit the generated files as required by Siebel Technical Notes, Siebel Alerts, Siebel CRM Update Guide and Release Notes on My Oracle Support or other publications before transferring them to the z/OS host.

    1. Required Tasks for Generating the Upgrade Files.

    2. Restarting the Siebel Upgrade Wizard After Pauses.

    3. Preparing the Additive Schema and JCL Files on the z/OS Host.

    4. Restarting the Siebel Upgrade Wizard After Pauses.

    5. Preparing and Executing the Nonadditive Schema and JCL Files on the z/OS Host.

    6. Restarting the Siebel Upgrade Wizard After Pauses.

    7. Processing the Index Schema File.

    8. Building JCL Templates for the Target Database.

  4. Upgrade the target database by performing the following tasks:

    1. Dropping Partitioned EIM Tables.

    2. Process of Upgrading the Target Database.

    3. Performing the In-Place Target Database Upgrade.

  5. Upgrade the repository and import seed data as described in Upgrading the Repository and Importing Seed Data.

  6. About the Siebel Upgrade Log Files.

  7. If the upgrade contains unacceptable errors, do the following:

    1. Restore the backup of the database that you made previously (see Preparing Developers for the Upgrade).

    2. Correct the errors.

    3. Rerun the Database Configuration Wizard.

  8. Activating New License Keys After an Upgrade.

  9. Back up the upgraded database repository.