Staging and Target Database Planning

When scheduling your upgrade, be aware that the target database schema must not be changed after the staging DDL is produced. If target database schema changes are applied before the upgrade is completed, you must recreate the staging database and generate the upgrade files again.

When planning your upgrade, keep in mind the following:

  • The staging database must be in a separate DB2 subsystem to the target database

  • The staging database table space names must be same as those in the target database

  • The staging database tableowner and storage group names can be the same or different to the target database names