DB2 Replication Guide and Reference

Navigating to Your Replication Objects with the Control Center

You can access your replication sources and targets through the Control Center interface. 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 relational 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 definitions for copying updated source data to target tables.

Figure 13 shows the Control Center. The folders you use for replication tasks are in the tree structure on the left side of the window, called the object tree.

Figure 13. The Replication Folder Objects in the Control Center Window. The Replication folder objects are used to administer your replication environment.

Each object also has a menu with the actions that can be performed with the object. In Figure 13, a table object has been selected and the pop-up menu is displayed with the Define as replication source action selected.

To access the replication folders and objects:

1. From the Control Center window, expand the object tree until you find the replication folder that you need to use: Tables, Replication Sources, or Replication Subscriptions.

2. Click on the folder. All objects contained in the folder are displayed in the pane on the right side of the window (the contents pane).

3. Click mouse button 2 on the object you want in the contents pane and select an action from the pop-up menu. A window related to the action opens or a process is launched.

In addition, some actions can be performed against an entire folder. For example, you can refresh the Replication Sources folder.

Configuring the Control Center for Non-DB2 Universal Database RDBMSs

If you are connecting to a DB2 for MVS, DB2 for VSE, or DB2 for VM source or target database server from the Control Center, you must bind the database to the Control Center.

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 installation drive of the Capture program.

2. Create and bind the DB2 for MVS, VSE, or VM package to the DB2 database by entering the following command:

   DB2 BIND @DDCSxxx.LST ISOLATION UR BLOCKING ALL SQLERROR CONTINUE
   

   Where UR specifies the list in uncommitted read format for greater performance and xxx specifies the platform name: MVS, VSE, or VM.

Additionally, you might need to perform an explicit connect from the Control Center. If the password is different than the local logon ID and password at the Control Center workstation, it is recommended that you explicitly connect to the database server using the Connect menu choice from the pop-up menu for the icon of your DB2 for MVS database.

[ DB2 List of Books | Search the DB2 Books ]