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

Required Tasks for Generating the Upgrade Files

Upgrades: All upgrades.

Environments: All environments.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

Complete the following tasks before starting to generate the upgrade files:

1. After you have created the staging database, you must extract the storage layout of the Siebel staging database from the DB2 catalog and merge it with a Siebel CRM storage control file so as to preserve any customizations you have made to the database layout in the upgraded database. To do this, run the Database Configuration Wizard and select the Extract from Catalog and Merge with Template option.

   Name the extracted storage control file as follows:

   • Development environment upgrade: storage_upg_dev.ctl
   • Production environment upgrade: storage_upg_prod.ctl

     For further information on this task, see Extracting the Storage Control File.

2. Validate the merged storage control file generated in Step 1 against the staging database. For information on this task, see Validating the Extracted Storage Control File. If there are validation errors, you must correct them before proceeding with the upgrade.
3. Rebuild tables in the target database that contain LONG VARCHAR columns. For information on this task, see Rebuilding Target Tables Containing LONG VARCHAR Columns.

   You can rebuild target tables at any time before you start the upgrade but you must have completed this task before you apply ADDITIVE schema changes to the production staging database.