Table 10. Information Required for the Database Configuration Wizard Upgrade Database Option
|
|
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. |