Replication Guide and Reference

Using the DB2 DataJoiner Replication Administration tool to set up replication

When you use the DB2 DataJoiner Replication Administration (DJRA) tool to perform replication administration tasks, DJRA connects to the source, target, or control server to create and update the control information and target tables on the server (depending on the operation performed). The client workstation where DJRA is located must be authorized and able to connect to all source, target, and control servers that are managed by DJRA.

For DB2 source, target, or control servers, DB2 DataJoiner's distributed database connection services (DDCS) or the DB2 Connect product provides connectivity. For non-IBM sources and targets, DJRA uses DB2 DataJoiner to connect to the non-IBM servers. Non-IBM databases cannot act as control servers.

DJRA provides a user interface that is divided into areas that deal with control tables, sources, subscription sets, and the running or editing of SQL (see Figure 16).

Using this interface, you can perform the following administration tasks:

Create replication control tables and put them on your source, target, or control servers
Define DB2 tables, non-IBM tables, and DB2 views as sources
Remove replication sources
Change the definitions for existing DB2 source tables to add new columns
Promote table, registration, and subscription definitions
Define subscription sets and subscription members
Change existing subscription members for DB2 target tables to add new columns
Remove subscription sets or subscription members that are no longer needed
Add SQL statements or delete SQL statements or stored procedures that should run before or after the target tables are replicated
Run or edit SQL that is generated by DJRA
Monitor replication
Perform an offline load of a table

You can also customize the logic for most of the administration tasks listed above.

Figure 16. The DJRA Primary Window

For more information on using DJRA, see DJRA overview.

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

[ DB2 List of Books | Search the DB2 Books ]