DB2 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.

Dropping Apply Program Views and Tables

Enter the following commands to drop the Version 1 Apply program tables:

```
set db2dbdft=mig_db
```
```
ASNMIG CLEANUP D=mig_db 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.
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.

Note:

For the Windows 95 and Windows NT platforms, when you specify parameters with the ASNMIG command for the CLEANUP action, you must surround those parameters with double quotes.

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

At the Version 1 control server:
- subscriber.IBMSNAP_REF_CNTL tables
- subscriber.IBMSNAP_REF_COLS tables
- subscriber.IBMSNAP_TRAIL tables
At the server where the subscriber's routing table resides:
- subscriber.IBMSNAP_ROUTING1 tables

Dropping Capture Program Views and Tables

Enter the following commands to drop Version 1 Capture program views and tables:

```
set db2dbdft=mig_db
```
```
ASNMIG CLEANUP D=mig_db S=data_serv 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.
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.

Note:

For the Windows 95 and Windows NT platforms, when you specify parameters with the ASNMIG command for the CLEANUP action, you must surround those parameters with double quotes.

After you enter this command, the following tables or views are dropped at the Version 1 source server, or at the copy server if auto-registration occurs:
- ASN.IBMSNAP_CD_CNTL1 table
- ASN.IBMSNAP_CD_CNTL view
- Version 1 pruning control views and backup pruning control tables
- ASN.IBMSNAP_AUTH table

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

[ DB2 List of Books | Search the DB2 Books ]