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 user-defined DB2 relational tables.
Replication Sources folder: The folder containing tables that have been defined as replication sources: DB2 tables, internal 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 folder 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 -> Custom action selected.

To access the replication folders and objects:

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

Replication Restrictions for Extended Enterprise Edition

Replication features are not available in DB2 Extended Enterprise Edition (EEE) V5. EEE table objects cannot be defined as replication sources or replication subscriptions. This means that replication menu choices are not available on EEE table, replication source, or replication subscription objects from within the Control Center.

Configuring the Control Center for Non-DB2 Universal Database RDBMs

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

To bind the database:

Change to the directory where the Capture program bind files are located, which is usually drive:\SQLLIB\BND.
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.
If your system does not support UR, substitute CS (cursor stability format) instead.

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, you must 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.

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

[ DB2 List of Books | Search the DB2 Books ]