About Running the Upgrade Database Option

When you run the Upgrade the Siebel Database option on the Database Configuration Wizard, the wizard prompts you for the upgrade environment (development or production) and the upgrade phase (upgrep, upgphys, or Prepare for Production Upgrade). The Wizard then prompts you for the information it requires about the upgrade environment to perform the upgrade.

After collecting and confirming the information, the wizard creates an upgrade configuration file and calls a driver that uses the environment information to create the SQL files required to upgrade your database.

After you run the Database Configuration Wizard, you run the Siebel Upgrade Wizard. The Siebel Upgrade Wizard opens a driver file containing the steps for the upgrade and executes these steps.

To upgrade a development environment, production test environment, or production environment, you must run the Database Configuration Wizard (and Siebel Upgrade Wizard) several times, as shown in the following table.

Upgrade Step	Select This Environment Type	Select This Upgrade Option(s)
Development environment upgrep	Development	upgrep: zSeries Staging of Files for Upgrade
Development environmentupgrep	Development	upgrep: zSeries Seed/Repository Upgrade
Development environment upgphys	Development	upgphys
Production test environment prepare for production (7.5.3 Upgrades only)	Production	Prepare for Production Upgrade
Production test environmentupgrep + upgphys	Production	upgrep + upgphys: zSeries Staging of Files for Upgrade
Production test environmentupgrep + upgphys	Production	upgrep + upgphys: zSeries Seed/Repository Upgrade
Production environmentupgrep + upgphys Note: If you have completed a production test upgrade and have tuned the SQL and JCL upgrade files on the z/OS host, you can use these files to perform the target database upgrade in the production environment. In this case, you do not have to run this upgrade step.	Production	upgrep + upgphys: zSeries Staging of Files for Upgrade
Production environmentupgrep + upgphys	Production	upgrep + upgphys: zSeries Seed/Repository Upgrade

The following image shows how the Database Configuration Wizard (and Upgrade Wizard) work together with the Siebel Tools repository merge to upgrade your environments. The steps shown in the following image are as follows:

1. Development Environment Upgrade:

   1. Upgrade Siebel database schema (Upgrep)

   2. Repository merge (Siebel Tools)

   3. Upgrade custom database schema (Upgphys)

2. Merged repository and schema files from development environment are sent to production test environment.

3. Production Test Environment Upgrade:

   1. Prepare for production

   2. Upgrade Siebel database schema (Upgrep and Upgphys)

   3. Upgrade tuning.

4. Transition to Production.

Note: The Prepare for Production step is required for upgrades from Siebel CRM version 7.5.3 only.