Replication Guide and Reference

Dropping Version 1 Control Tables and Migration Control Tables with CLEANUP

If all replication components in a network are migrated and perform satisfactorily, you can run the ASNMIG command with the CLEANUP action to drop Version 1 views and tables at the Version 1 control, source, and target servers. Before you enter the command, be aware that you cannot fall back after entering the command.

Enter the following command to clean up the Version 1 views and tables:

ASNMIG CLEANUP D=
mig_db S=
data_serv C=
v5_ctrl_serv T=
rout_serv U=
sub_id (V=
ver)

Where:

mig_db

Name of the migration database where the global control tables are stored. This is a required parameter.

data_serv

Version 1 source server. This is a required parameter.

v5_ctrl_serv

Version 5 control server. This is a required parameter.

rout_serv

Server where the routing table resides. This is a required parameter.

sub_id

Subscriber ID of an Apply program process. This is a required parameter.

ver

Version of the migration data that you want to clean up. If you do not specify this parameter, ASNMIG CLEANUP selects the latest version number. This is an optional parameter.

After you enter this command, the following tables or views are dropped:

• At the Version 1 source server:

  • ASN.IBMSNAP_CD_CNTL1 table

  • ASN.IBMSNAP_CD_CNTL view

  • Migration pruning control views and backup pruning control tables

  • ASN.IBMSNAP_AUTH table

• At the Version 1 control server:

  • subscriber.IBMSNAP_REF_CNTL tables

  • userid.IBMSNAP_REF_COLS tables

  • userid.IBMSNAP_TRAIL tables

• At the Version 1 target server (Version 5 target server):

  • userid.IBMSNAP_ROUTING1 tables

  • ASN.IBMSNAP_AUTH table

  • ASN.IBMSNAP_CD_CNTL1 table, ASN.IBMSNAP_CD_CNTL view, and pruning control views if auto-registration occurs

[ DB2 List of Books | Search the DB2 Books ]