ignore_set_null

Use this system parameter to specify whether CDC Replication replicates UPDATE operations on a replicated table that result from the delete of parent rows in tables with referential integrity relationships (ON DELETE SET NULL rule).

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 does not replicate UPDATE operations at child tables that result from the ON DELETE SET NULL rule. Only the deletion of the parent row is replicated. This option can be useful if you have the ON DELETE SET NULL rule in force at the target database and do not need these updates replicated.
FALSE: Specifies that when a parent row is deleted at the source, CDC Replication replicates the UPDATE operations from child rows in which one or more column values are set to NULL.

Default Setting

FALSE