1. Database Upgrade Guide
  2. Perform Preupgrade Tasks for IBM DB2

Perform Preupgrade Tasks for IBM DB2

  1. Perform the tasks in Preparing an IBM DB2 Database for a Siebel Upgrade

  2. If you are disabling archive logging, then allow time for a cold backup when reenabling archive logging.

  3. Apply runstats to all tables, reorganize any that are out of cluster, or that are clustered less than 90%, then execute runstats on those tables again. This will improve performance and reduce the number of tasks that will need to be done after the upgrade is complete.