ignore_trigger

Use this system parameter to specify whether CDC Replication ignores (that is, does not replicate) triggers.

Versions supported—CDC Replication Engine for Db2® Database version 10.2.1 Interim Fix 2 and later

This system parameter is only applicable when your database is DB2® for LUW version 10.1 and later.

Applies to

Source datastores

Values

Set this parameter to one of the following values:

TRUE: Specifies that CDC Replication will not replicated DML operating that have been generated by a trigger. This option can be useful if you have matching triggers on the target database and do not need trigger-generated operations to be replicated.
FALSE: Specifies that CDC Replication will replicate trigger-generated DML operations.

Default Setting

FALSE