Replication Guide and Reference

Creating replication control tables using DJRA

You must create control tables at each DB2 (and DataJoiner) system involved in replication. For DB2 Universal Database systems, you can use the DB2 Control Center or DJRA to perform this task; for other systems, including DB2 for OS/390, DB2 for AS/400, and all non-IBM databases, you must use DJRA. When you complete this step, DJRA places a register table, a pruning control table, and a register synchronization control table at the database source (and for non-IBM sources, creates nicknames for these tables in DB2 DataJoiner).

From the DJRA primary window, click the Create Replication Control Tables. The fields you complete in order to create a control table are:

Source, control, or target server

When you click the down arrow, DJRA checks to see what type of server it is and then lists all databases and aliases that are catalogued on the workstation from which you are running DJRA. If you select a DataJoiner server from the list, the DataJoiner non-IBM source server pull-down list becomes active. If you do not choose a DataJoiner server, you will link directly to a DB2 database.

DataJoiner non-IBM source server

If you selected a DataJoiner alias from the Source, control, or target server pull-down list and you have performed server mappings in DataJoiner, then this list displays available remote server names.

Specify (None) if you want the control tables to be created in the DataJoiner database rather than in the remote server database.

Edit Tablespace Logic

Click this push button to customize table space names for control tables or for CREATE TABLESPACE options. The default table space names are:

• TS_UOW for the UOW table

• TS_CNTL for all other control tables

Generate SQL

Click this push button to generate SQL after you supply all the information on this panel. While the SQL is being generated, a window is displayed showing processing messages and error messages, if any.

When the procedure completes successfully, save the file by selecting Save from the File pull-down menu. You can now edit the generated SQL, according to the guidelines that are listed in Editing DJRA-generated SQL. When you are ready, run the SQL by selecting Run from the File pull down menu. You must save the generated SQL before you can run the SQL. You must run the SQL for generating control tables before you generate and run SQL to create replication sources or subscriptions.

[ DB2 List of Books | Search the DB2 Books ]