Replication Guide and Reference

Collecting Data with BUILDDB

Enter the following command to collect Version 1 registration and subscription information from the servers in your replication environment:

ASNMIG BUILDDB
mig_db serv_list

Where:

mig_db

Name of the migration database where you want to store the global control tables. The database must already exist before you can enter a value for this parameter. This is a required parameter.

serv_list

List of databases from which you want to gather Version 1 replication information. At least one database alias name is required. Additionally, you can use an asterisk (*) as a wildcard if you want BUILDDB to add to the list of servers as it runs. This is a required parameter.

BUILDDB puts a collection trace into the BUILDDB.TRC file, and puts SQL statements that must be executed in DB2 into the BUILDDB.SQL file.

When you specify the wildcard character, *, in your replication network, BUILDDB examines all of the replication definitions for the servers provided and found in the userid.IBMSNAP_ROUTING, userid.IBMSNAP_REF_CNTL, userid.IBMSNAP_TRAIL, and userid.ASN. timestampPC tables. The migration database contains global control tables that store registration and subscription details for these servers.

BUILDDB.SQL creates a new version of migration analysis data in your migration database every time you run it. The ASN.VERSION_CONTROL table contains the version and timestamp history of when you last executed BUILDDB.

[ DB2 List of Books | Search the DB2 Books ]