Upgrade Guide for DB2 UDB for z/OS and OS/390 > Upgrading the Database >

Preparing to Run the Database Server Configuration Utility


Upgrades: All upgrades.

Environments: All environments.

This topic is part of an upgrade process. See How to Perform the Upgrade.

Use this topic to identify the information you must enter when running the Database Server Configuration utility. Collect this information and verify it before running the utility.

The Database Server Configuration utility requests information about the upgrade process you want to perform. It then adds this information to a master upgrade file and calls an SQL generator. The SQL generator uses the information to create or populate SQL files.

The Siebel Upgrade Wizard runs after the Database Server Configuration utility exits. The wizard executes the SQL files against the Siebel Database.

Under Windows, the Database Server Configuration utility is a wizard that displays a series of windows. You enter the requested information in each window. Most of the windows contain a help button. When you click the help button, an explanation of what to enter in the wizard displays.

Under UNIX, the Database Server Configuration utility displays as a set of screens in a shell command window. You enter the requested information at the prompt.

Table 18 lists the information that you must enter in the Database Server Configuration utility.

Table 19 lists additional information the utility requires when you perform a production environment or production upgrade.

For more information on the Database Server Configuration utility, see About the Database Server Configuration Utility.

Table 18. Information Required for the Database Server Configuration Utility
Screen Name
Required Information

Siebel Gateway Name Server Address

Windows only. The Siebel Gateway Name Server machine name and the Enterprise Server name.

Siebel Server Directory

The absolute path of the directory where the Siebel Server is installed. For UNIX, do not enter the string $SIEBEL_ROOT—for example D:\sea_7x\siebsrvr.

Siebel Database Server Directory

The absolute path of the directory where the Siebel Database Server is installed—for example D:\sea_7x\dbsrvr.

RDBMS Platform

Choose IBM DB2 UDB for z/OS.

Siebel Database Operation

Choose Upgrade Database.

The other menu choices are for database installation and administration.

Environment Type

Choose Development for development environment upgrades.

Choose Production for production environment upgrades.

Upgrade Options

Choose Upgrade Siebel Database Schema (upgrep + upgphys).

Siebel Industry Application

This displays if you are upgrading from a Siebel Industry Solution or Siebel Industry application.

Choose the application you are upgrading from.

If you have upgraded to the base Siebel eBusiness application as part of upgrading to the new Siebel Industry application release, choose Siebel Horizontal application.

Current Siebel Version

Choose the application version you are upgrading from.

Language

Select the appropriate language for your upgrade.

Source Database ODBC Data Source Name

Verify the ODBC name for connecting to the source Siebel Database for your upgrade. If it is not correct, enter the correct ODBC name.

The ODBC data source must have the same name as the subsystem. When you set up the ODBC connection in DB2 Connect, use the actual subsystem name for the database alias.

Windows: To find the name of your ODBC data source, navigate to Start > Settings > Control Panel > Administrative Tools > Data Source (ODBC). Click the System DNS tab to find the name of your ODBC data source.

UNIX: To find the name of your ODBC data source, type:
vi $ODBCINI.

Source Database User Name

Enter the source user name and password for the Siebel administrator of the source database for your upgrade.

NOTE:  The source database user name (user ID) needs to have authorization to set CURRENT SQLID.

Source Siebel Schema Qualifier

Enter the eight-character identifier that designates the Siebel Schema for your source database. This is also an authorization ID. The schema qualifier must start with a letter, cannot contain special characters, and must be entered in uppercase.

Target Database ODBC Data Source Name

Verify the ODBC name for connecting to the target Siebel Database for your upgrade. If it is not correct, enter the correct ODBC name.

The ODBC data source must have the same name as the subsystem. When you set up the ODBC connection in DB2 Connect, use the actual subsystem name for the database alias.

Target Database User Name

Enter the target user name and password for the Siebel administrator of the target database for your upgrade.

NOTE:  The target database user name (user ID) needs to have authorization to set CURRENT SQLID.

Target Siebel Schema Qualifier and Target Security Group ID

Enter the following parameter values:

Target Schema Qualifier. Enter the up to eight-character identifier that designates Siebel Schema for your target database. This is also an authorization ID. The schema qualifier must start with a letter, cannot contain special characters, and must be entered in uppercase.

Target Security Group ID. Enter the user ID of the group to whom schema access is granted, for example, SSEROLE.

Storage Group for Temporary Indexes

Enter the following parameter values:

Storage Group for Temporary Indexes. Enter the name of the storage group provided by the database administrator (the default value is SYSDEFLT).

Storage Control File. Use either of the following methods to select the storage control file (that you prepared in Preparing the Storage Layout of the Schema) that contains the previously customized database storage layout:

  • Windows: Accept the default value displayed in the Storage Control File field (this is the DBSRVR_ROOT\DB2390 directory. For example, D:\DBSRVR_ROOT\DB2390\storage.ctl) or use the Browse button to navigate to a different directory.
  • UNIX: Enter the path to your storage control file.

Primary Quantity for Temporary Index Space

Enter the primary and secondary quantities for temporary index space.

DDL Commit Frequency

Enter the DDL commit frequency for your upgrade.

DDL Output Directory

Accept the default or enter the directory name.

NOTE:  When this process is complete, this directory contains all of the files necessary to create the Siebel Database schema. These files must be manually applied by the database administrator.

Log Output Directory

Accept the default or enter the directory name. If the directory does not exist, it will be created. Do not use special characters such as spaces, slashes, or symbols in the name of the log output.

CAUTION:  If you are restarting or recovering a previous incomplete upgrade, do not change the Log Output Directory that you previously selected.

Additional Information Required for Production Upgrades

When you perform a production environment upgrade, the additional information shown in Table 19 is required when you run the Database Server Configuration utility in your production environment.

Note that several screens request information about the Siebel Database in the development environment, not the production test or production environment.

Table 19. Additional Information Required for Production Upgrades
Screen Name
Required Information

ODBC Data Source Name for Development Database

Windows only. The ODBC name for connecting to the development environment Siebel Database. If you are upgrading without a development environment, this is the ODBC of the reference database.

Database User Name for Development Database

Account name and password of the Siebel administrator of the Siebel Database in the development environment.

Database Table Owner for Development Database

Account name and password for the Siebel Database table owner in the development environment.

Import Repository Name

Enter the name of the upgraded Siebel Tools repository in the development environment database. Typically, this is Siebel Repository.

Upgrade Guide for DB2 UDB for z/OS and OS/390