Replication Guide and Reference

Using the DB2 Control Center to set up replication

When setting up the replication environment, you can use the DB2 Control Center to manage the source and target table definitions and the control tables. Use the following high-level steps to administer your replication objects:

1. Check, and optionally update, the default settings in the Tools Settings notebook. See Setting replication preferences in the DB2 Tools Settings notebook for more information.

2. Review the DPCNTL file for your platform to determine whether you need to customize the control tables for your site.

3. Optionally customize the DPCNTL file for your platform and site requirements. See Defining replication control tables for more information.

4. Define and manage replication sources. See Defining replication sources for more information.

5. Define and manage replication subscriptions. See Defining replication subscriptions for more information.

After you create the control tables and define the replication sources and targets, you need to configure and run the Capture and Apply programs to begin replicating data.

You can access your replication sources and targets through the Control Center. There are three containers in the Control Center for organizing the objects that you use to set up and maintain your replication environment:

Tables folder

The folder containing DB2 tables.

Replication Sources folder

The folder containing tables that have been defined as replication sources: DB2 tables, views, or target tables redefined as sources for replication.

Replication Subscription folder

The folder containing subscription-set definitions for copying source data or source-data changes to target tables.

Each object also has a menu for the actions that can be performed with the object.

Configuring the Control Center for host RDBMSs

If you are connecting to a DB2 for OS/390, DB2 for VSE, DB2 for VM, or DB2 for AS/400 server from the Control Center, you must configure connectivity to the remote database, catalog the remote databases, and bind packages to the remote databases.

To bind the database:

1. Change to the directory where the Capture program bind files are located, which is usually the \SQLLIB\BND directory on the drive where you installed DB2 Universal Database or the client application enabler (CAE).

2. Create and bind the DB2 for OS/390, VSE, VM, or AS/400 package to the DB2 database by issuing the following commands:

   DB2 CONNECT TO dbname USER userid USING password
   DB2 BIND @DDCSxxx.LST ISOLATION CS BLOCKING ALL SQLERROR CONTINUE
   

   Where CS specifies the cursor stability isolation level, and xxx specifies the platform name: MVS, VSE, VM, or AS/400.

   If the user ID and password are different than the local logon ID and password for the Control Center workstation, you must explicitly connect to the database server using the Connect menu choice from the pop-up menu for your remote database object.

Setting replication preferences in the DB2 Tools Settings notebook

The Tools Settings notebook contains default preferences for the DB2 Universal Database administration tools. You can set replication default values on the Replication page of the notebook, as shown in Figure 15. These default values are used for all replication activities administered by the Control Center.

Figure 15. The Replication Page of the Tools Setting Notebook

[ DB2 List of Books | Search the DB2 Books ]