Preupgrade Tasks for the Siebel Database

1. Review guidelines for configuring DB2 for z/OS. For information, see Implementing Siebel Business Applications on DB2 for z/OS.

2. Verify that the Workflow Monitor and Workflow action agents have processed all pending requests.

3. Remove customized database triggers.

   The Siebel upgrade process is not designed to support custom database triggers. If you have created customized triggers for the Siebel schema to be upgraded, you must remove them before starting the Siebel upgrade process. You can re-create these objects once the Siebel upgrade completes successfully.

4. Prepare the storage control file to use in the upgrade. See Process of Preparing the Storage Layout of the Schema.

5. Perform the tasks in:

   • Basic Database Preparations for a Siebel Upgrade

   • The chapter in Siebel Database Upgrade Guide that describes the basic database preparations for a Siebel upgrade

6. Before starting the production test upgrade, ensure that:

   • Siebel database transactional tables with clustering indexes are organized in cluster sequence.

   • Generate database statistics for your Siebel database transactional tables, if required.