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

Information Required by the Database Configuration Wizard


Upgrades: All upgrades.

Environments: All environments.

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

Use this topic to identify the information you must enter when running the Database Configuration Wizard. Make sure you have prepared your upgrade environment, and have collected and verified this information before running the wizard.

The Database Configuration Wizard requests information about the upgrade process you want to perform. It then adds this information to a master upgrade file. The Siebel Upgrade Wizard runs after the Database Configuration Wizard exits. The wizard generates the upgrade SQL files and executes some of the SQL files against the Siebel database. For more information on the Database Configuration Wizard, see About the Siebel Database Configuration Utilities and Database Configuration Wizard.

Table 10 lists the information that you must enter in the Database Configuration Wizard when performing the upgrade processes. Table 11 lists additional information the utility requires when you perform a production environment upgrade.

Table 10. Information Required for the Database Configuration Wizard Upgrade Database Option
Field Name or Menu
Required Information

Gateway Name Server Address

Enterprise Server Name

The Siebel Gateway Name Server computer name.

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.

Siebel Database Server Directory

The absolute path of the directory where the Siebel Database Configuration Utilities are installed, for example C:\sba81\dbsrvr (Windows) or siebel/dbsrvr (UNIX).

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 and production test environment upgrades.

Upgrade Options

 

Choose one of the following:

  • Upgrade Siebel Database Schema (upgrep): development upgrades only
  • Upgrade Custom Database Schema (upgphys): development upgrades only
  • Prepare for Production Upgrade: production upgrades only
  • Upgrade Siebel Database Schema (upgrep + upgphys): production upgrades only

Upgrade Process

Choose one of the following:

  • zSeries Staging of Files for Upgrade: to create the staging database DDL and to generate upgrade files
  • zSeries Seed/Repository Upgrade: to automatically populate and upgrade data on the database

Siebel Industry Application

This screen appears 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 Business Applications as part of upgrading to the new Siebel Industry Applications release, choose Siebel Business Application (HOR).

Current Siebel Version

Choose the application version you are upgrading from.

Database Encoding

Indicate whether your database uses an ASCII or EBCDIC code page.

Language Selection

Upgrades with more than one language pack installed only.

Select the primary (base) language from the list of language packs installed in your enterprise. The primary language is the language in which the data is stored in the Siebel database to be upgraded.

Multilingual Deployments

Upgrades with more than one language pack installed only.

Indicate whether or not you have deployed multiple languages in your Siebel Enterprise. All languages that you have installed, and for which you have run the Multilingual List of Value conversion process, are upgraded.

ENU Upgrades

Upgrades with more than one language pack installed only.

Specify whether or not American English (ENU) is to be upgraded in addition to the base language.

  • Select Yes if American English (ENU) has been added to the database and is to be upgraded.

    For ENU to be upgraded, ENU must have been added to the database and the ENU language pack must be installed

  • Select No if American English (ENU) has not been added to the database.

    If American English (ENU) has not been added to the database, it is not upgraded even if the ENU language pack is installed.

For additional information on upgrading multilingual Siebel deployments, see Siebel Database Upgrade Guide.

Host/LPAR name where Target database resides

 

DB2 Subsystem name of Target database.

  • Host/LPAR name where Target database resides. The name of the host or LPAR where the target database is located. You can either specify the same or different Host/LPAR names for the target and staging databases.
  • DB2 Subsystem name of Target database. The DB2 subsystem name of the target database. You must specify a different DB2 subsystem name for the target and staging databases.

Schema/Tableowner qualifier name on Target database

Enter the up to eight-character identifier that designates the 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. The target database tableowner name can be the same or different to the staging database tableowner name.

ODBC Data Source Name of Target database

Verify the ODBC name for connecting to the target Siebel database.

The default value of the target database ODBC DSN is the DB2 subsystem name. When you set up the ODBC connection in DB2 Connect, you can use the actual subsystem name for the database alias.

NOTE:  To find the name of your ODBC data source, navigate to the Start menu, then select Settings, Control Panel, and then ODBC data source. Click the System DSN tab and you will find the name of your ODBC data source.

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

Valid/Authorized Target database user name or group name

Valid/Authorized Target database password

Enter the target database user name and password for the Siebel administrator of the target database. For further information on the database user name, see Granting a Siebel User Upgrade Authorization.

Host/LPAR name where Staging database resides

 

DB2 Subsystem name where the Staging database resides

  • Host/LPAR name where Staging database resides. The host or LPAR name of the staging database. The staging and target Host/LPAR names can be the same or different.
  • DB2 Subsystem name where Staging database resides. The DB2 subsystem name of the staging database. You must specify different DB2 subsystem names for the target and staging databases.

Schema/Tableowner qualifier name for Staging database

Enter the up to eight-character identifier that designates the Siebel schema for your staging 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. The staging database tableowner name can be the same or different to the target database tableowner name.

Authorized TSO account ID used to connect and FTP files to Enterprise Server(s)

Enter your TSO account ID. This account ID must have the authorization to allocate and create data sets on the z/OS host.

Dataset High-level Qualifier for all Host (Staging and Target) dataset names

Specify the high-level qualifier you want to use for the z/OS upgrade data sets. Follow your organization's naming standards.

Security Group ID / Grantee.

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

Storage Group for Temporary Indexes

 

 

Storage Control File

Storage Group for Temporary Indexes. Enter the name of the storage group provided by the database administrator for the staging database (the default value is SYSDEFLT). The staging database storage group name can be the same or different to the target database storage group name.

Storage Control File. Enter the path and name of the storage control file you want to use as follows:

  • zSeries Staging of Files for Upgrade: When you select this upgrade process, specify the storage control file of the target database.
  • zSeries Seed/Repository Upgrade: When you select this upgrade process, specify the storage control file that contains the previously customized database storage layout (this is the file you prepared in Preparing the Storage Layout of the Schema).

Primary Quantity for Temporary Index Space

Secondary Quantity for Temporary Index Space

Enter the minimum amounts of primary and secondary index space allocated for temporary indexes generated during the upgrade.

DDL Commit Frequency

Enter the DDL commit frequency for your upgrade.

Output Directory

Accept the default output directory name or enter a new directory name.

NOTE:  When the upgrade process is complete, this directory contains all of the files necessary to create the staging database or run the upgrade. These files must be manually applied by the database administrator.

Log Output Directory

Accept the default output directory for upgrade log files name or enter a new directory name.

Additional Information Required for Production Upgrades

If you are upgrading from Siebel CRM version 7.5.3, when you perform a production environment upgrade, you are prompted to enter the additional information shown in Table 11 when you run the Database Configuration Wizard in Prepare for Production Upgrade mode.

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

Table 11. 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

Database Password for Development Database

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

Siebel Schema Qualifier for Development Database

Enter the up to eight-character identifier that designates the Siebel schema for your development 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.

Repository Name for Development Database

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

Siebel Database Upgrade Guide for DB2 for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.