Command Reference

MIGRATE DATABASE

Converts previous versions of DB2 databases to current formats. Following are the database releases that are supported in the DB2 V5.0 database migration process:

DB2 for OS/2 Version 1.x and Version 2.x to Version 5.0
DB2 for AIX Version 1.x and Version 2.x to Version 5.0
DB2 for HP-UX Version 2.x to Version 5.0
DB2 for Solaris Version 2.x to Version 5.0
DB2 for Windows NT Version 2.x to Version 5.0
DB2 Parallel Edition Version 1.x to Version 5.0.

Authorization

sysadm

Required Connection

This command establishes a database connection.

Command Syntax

>>-MIGRATE---+-DATABASE-+database-alias-------------------------> +-DB-------+ >--+---------------------------------------+------------------->< +-USER--username--+------------------+--+ +-USING--password--+

Command Parameters

DATABASE database-alias: Specifies the alias of the database to be migrated to the currently installed version of the database manager.
USER username: Identifies the user name under which the database is to be migrated.
USING password: The password used to authenticate the user name. If the password is omitted, but a user name was specified, the user is prompted to enter it.

Example

The following example migrates the database cataloged under the database alias sales:

   db2 migrate database sales

Usage Notes

This command will only migrate a database to a newer version, and cannot be used to convert a migrated database to its previous version.

The database must be cataloged before migration.

Use db2ckmig - Database Pre-migration Tool to determine whether the database can be migrated. For more information, see one of the Quick Beginnings books.
Note: Back up all databases prior to migration.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]