Set Up the Target Database

1. Back up and remove the upgraded test database.

   This preserves seed data and metadata changes you have made that must be migrated to the production environment. This database is called the production-test final database.

2. In the test environment, install a recent backup of your production database.

   This database has not been upgraded and is called the target database. You will use it to perform test upgrades as part of tuning upgrade performance.

3. Define an ODBC connection to the target database.

4. Verify that the target database and RDBMS server are configured for optimum upgrade performance:

   • Preparing an IBM DB2 Database for a Siebel Upgrade

   • Preparing an Oracle Database for a Siebel Upgrade

   • Preparing a Microsoft SQL Server Database for a Siebel Upgrade

5. Preparing Siebel Tables and Views for Upgrade.

6. Run statistics on the target database. This optimizes query performance.

7. UNIX. Securing AIX Memory Allocation Segment Space for the Siebel Database.

8. Perform the tasks in Preparing Siebel Application Data for Upgrade