Upgrade Guide for DB2 UDB for z/OS and OS/390 > Basic Database Preparations >

Preparing Tables and Views for Upgrade

Upgrades: All upgrades.

Environments: All environments.

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

To prepare tables and views for upgrade

1. Drop temporary tables and non-Siebel tables.

   If the upgrade process detects a column with a datatype not acceptable to Siebel tables, the upgrade will fail.

2. Disable customized triggers.

   You must re-create them after the upgrade.

3. Drop defined database views on Siebel tables.

   You must re-create them after the upgrade.

4. Export interface table data that you want to preserve.

   Interface tables are dropped and then re-created during upgrade. You can import the data after the upgrade.