DB2 Replication Guide and Reference

Invoking the Migration Program and Actions

You can invoke the migration program by entering the following command followed by an action and two or more required parameters. If you enter the command without entering an action, syntax help is provided.

ASNMIG action parameters

Where action is one of the following choices:

BUILDDB

Required action that gathers Version 1 replication definitions and saves them in an ASCII file named BUILDDB.SQL (default name). After completing this action, you must execute this file using the DB2 -TF command to create the migration global control tables and insert rows to these tables. The SQL statements for creation of these tables appear in the BUILDDB.SQL file only if one or more of the tables does not exist.

PREPARE

Required action that either transforms incompatible Version 1 column values into compatible Version 5 values, or informs you about non-tranformable Version 1 values.

MIGRATE

Required action that migrates from Version 1 to Version 5.

FALLBACK

Optional action that reverts from Version 5 to Version 1.

CLEANUP

Optional action that drops unused Version 1 tables and views after successful migration.

The following sections explain how to use each action and its associated parameters.

[ DB2 List of Books | Search the DB2 Books ]