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.

Fields and controls



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

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

    2. Type the name of the file and its path name, if different from DPREPL.DFT, in the File name field. Initially, the template file DPREPL.DFT is located in the SQLLIB\SAMPLES\REPL 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 into the working directory for the Control Center (for example, SQLLIB\BIN) so that the system can use it as the default 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