Upgrade Guide for DB2 UDB for z/OS > 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.

   Release 7.8 does not support customized triggers. If you have created customized triggers on your Siebel base tables, disable them before you perform the upgrade. You must recreate them after the upgrade is finished.

3. Drop customized views on Siebel tables.

   If you created customized views on Siebel base tables, you must drop them before you perform the upgrade. If they are still applicable after the upgrade, you must recreate them after the upgrade is finished.

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.