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

Preparing for a Non-Development-Environment Upgrade


Upgrades: All upgrades.

Environments: Production test, production.

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

If your installation does not include a development environment, you do not need to merge your Siebel Repository. Instead, you can use the repository and schema definition files included in the Siebel Database Server installation.

Before performing the upgrade, you must move and rename these files.

To prepare for a non-development-environment upgrade

  1. Navigate to DBSRVR_ROOT\common (UNIX: DBSRVR_ROOT/common) and locate the mstrep.dat file.
  2. Copy the mstrep.dat file and rename it custrep.dat.
  3. Place the custrep.dat file in the DBSRVR_ROOT\DB2390 directory.
  4. In the DBSRVR_ROOT\DB2390 directory, copy the ddl.ctl file and paste the copy into the same directory.
  5. Rename the copy schema.ddl.
  6. In the production test environment create a new tablespace, separate from the Siebel Database.

    Install the Siebel Database from the new release in the new tablespace. Do not migrate any data to the new database.

    This database is called the reference database.

  7. Define an ODBC for the reference database.
Upgrade Guide for DB2 UDB for z/OS