Siebel Database Upgrade Guide for DB2 for z/OS > Running the Database Configuration Wizard to Perform Upgrade Tasks >

About Running the Database Configuration Wizard Under UNIX

Upgrades: All upgrades.

Environments: All environments.

Platforms: UNIX only.

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

Run the Database Configuration Wizard to upgrade the Siebel database. The wizard collects information, populates a master configuration file, and calls the SQL generator to create SQL commands. The Siebel Upgrade Wizard then uses the configuration file and SQL commands to generate upgrade files that are applied on the mainframe, and to make upgrade changes to the Siebel database. For more information on the Database Configuration Wizard, see About the Siebel Database Configuration Utilities and Database Configuration Wizard.

Requirements:

• Collect the information that the Database Configuration Wizard requires. See Information Required by the Database Configuration Wizard.
• Install the new release's languages packs for all deployed languages. For further information on multilingual upgrades, see the topic on upgrade planning for multilingual Siebel deployments in Siebel Database Upgrade Guide.

CAUTION:  When you run the Siebel Database Configuration Wizard to upgrade the Siebel Database, the procedure will not complete successfully if you have deployed languages within your system that are not shipped with Siebel CRM 8.1. You receive an error message stating that your present installation is incomplete, and a list of the languages that caused the error is displayed. If this error occurs, you must delete records for unshipped languages from the S_LST_OF_VAL database table. For information on this task, see the topic on running the Database Configuration Wizard in Siebel Database Upgrade Guide.

For a list of languages shipped by Oracle, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.

Running the Database Configuration Wizard Under UNIX

This topic describes the standard procedure to follow to run the Database Configuration Wizard under UNIX.

To run the Database Configuration Wizard under UNIX

1. Verify that the Siebel Server is stopped.

   The Database Configuration Wizard runs in live mode only so you must be connected to the Gateway Name Server to run it. For further information on Siebel Configuration Wizard running modes, see Siebel Installation Guide for UNIX.

2. Before running the Database Configuration Wizard under UNIX, you must configure your environment by running the CreateDbSrvrEnvScript script. To run CreateDbSrvrEnvScript:
   1. Navigate to the SIEBSRVR_ROOT/install_script/install directory, for example, home/siebel/siebsrvr/install_script/install.
   2. Run CreateDbSrvrEnvScript as follows:

   CreateDbSrvrEnvScript SIEBEL_ROOT LANG Database_Platform

   where:

   • SIEBEL_ROOT is the top-level Siebel Enterprise Server 8.1 installation directory, for example, /siebel
   • LANG is the three-letter code for the primary language of your Siebel database, for example, enu
   • Database_Platform is Db2.390

     CreateDbSrvrEnvScript creates two environment setup scripts, dbenv.sh and dbenv.csh, in the Siebel Server installation directory.

3. Navigate to the SIEBSRVR_ROOT/bin directory, and source either the dbenv.sh or the dbenv.csh file, according to the type of shell you use:
   • Korn or Bourne shell

   . ./dbenv.sh

   TIP:   Make sure there is a s pace between the initial period and ./dbenv.sh.

   • C shell

   source dbenv.csh

4. Review the values of the $SIEBEL_ROOT and LANGUAGE environment variables and verify that they are correct. If necessary, reset the values as follows:
   • Set the LANGUAGE variable to the language in which the Database Configuration Wizard prompts appear, for example, enu for U.S. English.
   • Set the $SIEBEL_ROOT variable to the path of your Siebel Server installation directory, for example, home/siebel/siebsrvr.
5. Start the Database Configuration Wizard by running the following command:

   $SIEBEL_ROOT/bin/ssincfgw -args LANG=language MODEL_FILE=$Siebel_Root/admin/dbsrvr.scm

   For a description of the command line syntax and options, see Siebel Installation Guide for UNIX.

6. When the first Database Configuration Wizard screen appears, enter the information you are prompted for in this screen, and click next to continue.
7. Enter the information you are prompted for in all subsequent screens. Use the Next and Back buttons to navigate between screens.
8. After you have entered all the requested information, the wizard displays the following message:

   Configuration is complete: configuration parameters will be saved to <$Masterfile> file when the wizard completes. Please run the following command line after you exit from this configuration wizard. This command will deploy the process you configured to the database.

   $SiebelRoot/siebsrvr/bin/srvrupgwiz /m $SiebelRoot/siebsrvr/bin/$Masterfile>

9. Click Next to continue. The utility displays the Parameter Review screen listing all the values you have entered.
10. To amend any of the configuration values, click Back to return to the appropriate screen and make changes. Otherwise, click Next.
11. You are prompted as to whether or not you want to execute the configuration:
    • Click Yes, and the configuration information is saved in a master file located in $SIEBEL_ROOT/bin but the Upgrade Wizard is not launched. To start the Upgrade Wizard, see Starting the Siebel Upgrade Wizard.
    • Click No, and the configuration information you entered is not saved.