Enabling use of foreign keys (referential integrity)

Replication with Infosphere CDC : solidDB® specific settings and tasks for IBM InfoSphere CDC : Enabling use of foreign keys (referential integrity)

If your subscriptions include tables with foreign keys, you need to set the IBM InfoSphere CDC for solidDB^® system parameter refresh_with_referential_integrity to true.

About this task

You can set system parameters

▪with the dmset -I <INSTANCE_NAME> <parameter_name>=<parameter_value> command, or

▪using the Management Console:

1 In the Configuration perspective of the Management Console, select the datastore.

2 Right-click on the datastore and select Properties > System Parameters.

If you make changes to a system parameter during active replication, you must stop and restart replication for the changes to take effect.

Procedure

Set the IBM InfoSphere CDC for solidDB^® system parameter refresh_with_referential_integrity to true.

For example:

dmset -I solidDB_1 refresh_with_referential_integrity=true