DB2 Version 9.7 for Linux, UNIX, and Windows

Instance and database migration commands and APIs have been deprecated

The db2imigr, db2ckmig, and MIGRATE DATABASE commands as well as the sqlemgdb and sqlgmgdb APIs have been deprecated in DB2® Version 9.7 and might be removed in a future release.

Details

To be consistent with the use of the term upgrade for DB2 products, the term upgrade is now used to describe the process of enabling pre-Version 9.7 DB2 servers, clients, database applications, and routines to run in a Version 9.7 environment. Pre-Version 9.7 refers only to DB2 Universal Database Version 8, DB2 Version 9.1, and DB2 Version 9.5.

The term upgrade is also used to describe the process of enabling pre-Version 9.7 instances and databases to run in a DB2 Version 9.7 copy.

Prior to Version 9.7, the term migration was used to describe the process of enabling DB2 servers, clients, database applications, routines, instances, and databases from one release to run in a later release.

Because of this change in terminology, the DB2 commands and APIs to migrate instances and databases have been deprecated, and new commands and APIs to upgrade instances and databases are available. The following table shows new Version 9.7 commands and APIs that you should use.

Table 1. Equivalent pre-Version 9.7 and Version 9.7 commands
Pre-Version 9.7 command or API name Version 9.7 command or API name Version 9.7 command or API description
db2imigr db2iupgrade db2iupgrade upgrades an instance to Version 9.7 from Version 8, Version 9.1, or Version 9.5.
db2ckmig db2ckupgrade db2ckupgrade verifies that the local pre-Version 9.7 databases are ready to be upgraded to Version 9.7.
MIGRATE DATABASE UPGRADE DATABASE UPGRADE DATABASE upgrades a database to Version 9.7 if the instance where the database was running was upgraded to Version 9.7 by using the db2iupgrade command.
sqlemgdb and sqlgmgdb db2DatabaseUpgrade db2DatabaseUpgrade converts a DB2 Version 9.5, Version 9.1, or Version 8 database to the current release.

User response

Use the new DB2 commands and APIs provided in Version 9.7 when upgrading instances and databases to Version 9.7.

Refer to "Upgrade to DB2 Version 9.7" for details about the complete upgrade process for DB2 servers, clients, database applications, and routines.