Upgrade Guide for DB2 UDB for z/OS > Preparing a Production Environment for Upgrade >

Transferring the Customized Repository and Schema Definition Files

Upgrades: All upgrades.

Environments: Production test and Production environments.

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

When you upgraded your development environment, the new customized repository was exported to a file called custrep.dat and the modified schema definition was exported to a file called schema.ddl in the DBSRVR_ROOT\DB2390 directory on the Siebel Server client machine from which you ran the upgrade.

Before doing a production or production test environment upgrade, you must copy the upgraded repository definition files (custrep.dat and schema.ddl) from the development environment to the production environment.

NOTE:  If you modified repository objects or schema definitions after completing the development upgrade (upgphys), you must regenerate the schema.ddl and custrep.dat files. See Regenerating the Repository Definition Files.

To move the repository and schema definition files to the production environment

1. In the development environment, navigate to the following directory:

   Windows: DBSRVR_ROOT\DB2390

   UNIX: DBSRVR_ROOT\DB2390

2. Copy the following files:

   custrep.dat

   schema.ddl

3. In the production environment, put these files in the following location:

   Windows: DBSRVR_ROOT\DB2390

   UNIX:DBSRVR_ROOT\DB2390

   The custrep.dat file will be used by the Siebel Upgrade Wizard to import the New Customer Repository. The schema.ddl file will be used by the Siebel Upgrade Wizard to create the new database schema.