Upgrade the Siebel Database Schema (upgrep + upgphys)

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

2. Generate the upgrade files by performing the following tasks:

   Note: Edit the generated files as required by Siebel Technical Notes, 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. Applying the Additive Schema Changes to the Production Staging Database.

   5. Restarting the Siebel Upgrade Wizard After Pauses.

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

   7. Restarting the Siebel Upgrade Wizard After Pauses.

   8. Processing the Index Schema File.

   9. Building JCL Templates for the Target Database.

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

   1. Read Process of Upgrading the Target Database.

   2. Dropping Partitioned EIM Tables.

   3. Creating and Loading Siebel Log Tables

   4. Applying Additive Upgrade Changes to the Target Database.

   5. Renaming the Production Environment Repository.

   6. Performing the In-Place Target Database Upgrade.

4. Extract the storage control file from the target database using the Database Configuration Wizard as follows:

   • Specify the following values when prompted to do so:

     • Extract Options: Extract from Catalog.

     • Storage Control File: Specify the name of the storage control file to be extracted. You must specify the name storage_postupg.ctl.

   • Make sure you specify values for the target database when prompted for the names of the schema Qualifier, ODBC data source, and database user name and password.

   The procedure to extract a storage control file using the Extract from catalog option is described in Implementing Siebel Business Applications on DB2 for z/OS. The extracted target database storage control file is used as input to the upgphys upgrade process.

5. Upgrade the repository and import seed data. See Upgrading the Repository and Importing Seed Data.

6. Activating New License Keys After an Upgrade.

7. About the Siebel Upgrade Log Files.

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

   1. Restore the backup of the database.

   2. Correct the errors.

   3. Rerun the Database Configuration Wizard.

9. Manually Archiving Upgrade Log Files.

10. Back up the upgraded database.