Setting replication properties

Use the Replication page of the Tools Settings notebook to set global properties for replication tasks. You can set properties for certain attributes of source table columns and target tables.

To set properties for replication tasks:

1. Open the Replication page of the Tools Settings notebook.

2. Specify whether to drop table spaces for target and change data tables when the table spaces are empty by selecting the Drop table space when empty check box.

3. Specify whether to capture the before image for source table columns by selecting a radio button under Source table column attributes.

4. Specify preferences for target table attributes by selecting one or more check boxes under Target table attributes.

5. Optional: Substitute user-defined values to define replication sources.

   1. Select the Substitute user-defined values to define replication sources check box.

   2. Type the name of the file and its path name, if different from DPREPL.DFT, in the File name field. By default, DPREPL.DFT is located in the SQLLIB\BIN directory.

   3. Open the file in your editor and add or change the table and index names as needed for defining replication sources, views, or subscriptions. Sample user-defined values and explanations for each entry are provided in DPREPL.DFT.

   4. Save the file.

      When you run your SQL, the Control Center will examine this file and substitute the values that you supplied as the default values.

6. Close the Tools Settings notebook by double-clicking in the upper left corner of the notebook.

Related information

• Defining replication sources
• Changing a replication source
• Defining a subscription
• Changing a subscription

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]