Upgrade Guide for DB2 UDB for z/OS and OS/390 > Preparing a Development Environment for Upgrade >

Prerequisites for a Development Upgrade

Upgrades: All upgrades.

Environments: Development environment only.

Before you upgrade your development environment, make sure that the development database configuration meets the database requirements outlined in Verifying Database Server Configuration, and meets the requirements depicted in the Siebel Installation Guide for the operating system you are using.

If your development environment platform is DB2 UDB for Windows and UNIX, see Upgrade Guide.

NOTE:  Make sure that the development database uses binary sort order. Production databases are not constrained by this requirement.

If you have not already done so, copy the Upgrade Planning Worksheet, located in Upgrade Planning Worksheet and fill out the appropriate fields with the following information.

• ODBC Data Source Name. This name must be the same as the name of the database qualifier. If you create a new datasource to use for your upgrade or installation other than the default ODBC datasource created by Siebel Systems, you must add the TXNISOLATION=1 parameter in the db2cli.ini file for the new datasource.
• Database User Name. Type 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 a Siebel Systems employee. The employee record must have the Siebel administrator responsibility. SADMIN is the default administrator user name and password. 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.

  This login must be the same as the database user name that you specify in the upgrade configuration utility.

• Database Password. Type the password for the ID used to log into the Siebel Database.
• Schema Qualifier. Type 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.
• Storage Group for Indexes. The name of the storage group used for temporary indexes. The default value is SYSDEFLT.