Enabling and disabling triggers

Modify a replicate to specify whether triggers are fired when replicated data is applied.

Prerequisite: With the Modify Replicate action, you can modify a strict master replicate and its participants. A master replicate verifies that replicated tables on different servers have consistent column data types. A strict master replicate also verifies that the replicated tables have identical column names.

By default, when a replicate causes an insert, update, or delete on a target table, triggers associated with the table are not fired. When you modify a replicate, you can specify whether triggers are fired when the replicated data is applied.

To enable or disable triggers:

  1. On the menu of the HCL OpenAdmin Tool (OAT) for Informix®, expand Replication, and then click Replicates.
  2. Click the Replicates tab.
  3. On the Actions menu, click Modify Replicate.

    The list displays the server groups in the domain with the participants in bold.

  4. Click Next.
  5. Specify whether to enable or disable triggers:
    • To enable triggers, select Fire triggers at destination.
    • To disable triggers, clear this option.
  6. To modify the replicate, click Finish.

    The options that you selected and the results of the action are displayed.

Copyright© 2018 HCL Technologies Limited