Administration Guide

Appendix B. Planning Database Migration

This section provides you with an overview of the migration process. Note that DB2 UDB Version 6 databases do not need to be migrated to Version 7. Detailed information about migrating your DB2 UDB Version 5.x databases can be found in the Quick Beginnings manual for your operating system.

When you migrate your database:

• The following database entities are migrated:
  • Database configuration file
  • Database system catalog tables
  • Database directories
  • Database log file header
• System catalog tables are changed as follows:
  • New columns are added.
  • New tables are created.
  • A set of catalog views is migrated, and a set of new catalog views is created in the SYSCAT schema.
  • A set of updatable catalog views is created in the SYSSTAT schema.
  • A set of general purpose scalar functions is kept, and a set of new general purpose scalar functions is created in the SYSFUN schema. Only the SYSFUN.DIFFERENCE scalar function is dropped and recreated during database migration.
• A database history file and its shadow are created in the database directory. This file contains a summary of backup information that can be used if a database must be restored, and it is updated whenever specific operations are performed on the database. A summary of backup information is also kept for backup and restore operations on a table space.