Upgrade Guide for DB2 UDB for z/OS and OS/390 > Preparing a Production Environment for Upgrade >
Prerequisites for a Production Upgrade
Upgrades: All upgrades. Environments: Production environment only. CAUTION: You must be thoroughly familiar with the upgrade process before beginning the production upgrade. Before upgrading your production environment, perform a test upgrade in your development environment to familiarize yourself with the process and to eliminate errors that can affect upgrade success or performance.
Before beginning the upgrade of your production environment, verify that the production database configuration meets the database requirements outlined in the section Verifying Database Server Configuration. NOTE: Verify that your production database uses binary sort order.
About Subsystems and Tableowners
Table 17 describes the subsystem and tableowner requirements for the production upgrade.
Table 17. Production Upgrade Subsystem and Tableowner Requirements
|
|
One subsystem |
Two tableowners |
Two subsystems |
One tableowner |
Two subsystems |
Two tableowners |
If you have not already done so, contact your database administrator and get the following information about your source database and your target database. Source Database Values
For the production environment upgrade, you need the following values for your source database:
- ODBC Data Source Name. This name must be the same as the name of the database qualifier.
NOTE: On Microsoft Windows, the Siebel Server installation process automatically creates the data source, using the format SiebSrvr_ EnterpriseName . To find the name of your ODBC data source, navigate to Start > Settings > Control Panel > ODBC data source. Click the System DSN tab and you will find the name of your ODBC data source.
- Database User Name. The ID allowed to log into the Siebel Database. This user ID should have authorization to set CURRENT SQLID and must be set up as an employee within your Siebel eBusiness application. The employee record must have the Siebel administrator responsibility. SADMIN is the default administrator user name and password, but you can use any name that has SADMIN credentials. If this user does not already exist in your database, or does not have Siebel administrator privileges, then you must add this to your database prior to proceeding with the upgrade. For more information, see Adding a Siebel User.
This login must be the same as the target database user name that you will specify in the upgrade configuration utility.
- Database Password. The password for the ID used to log into the Siebel Database.
- Schema Qualifier. The up to eight-character identifier that designates Siebel Schema. This is also an authorization ID. The schema qualifier must start with a letter, cannot contain special characters, and must be entered in uppercase.
- Group Authorization ID. The user ID of the group to whom schema access is granted, for example, SSEROLE.
Target Database Values
For the production environment upgrade, you need the following values for your target database:
The remaining information required for upgrade will be derived from your prior source database layout.
|