Restrictions on IBM InfoSphere CDC in IBM InfoSphere CDC Replication deployments
The following features that may be available in the IBM InfoSphere CDC components for other data servers are not supported in IBM InfoSphere CDC for solidDB®.
▪Fast load for refresh
IBM InfoSphere CDC for solidDB® does not support the fast load for refresh feature.
▪Automatic creation of target tables
If the tables meant to be mirrored are associated with referential integrity constraints, you cannot use the option of creating target tables automatically (Create new target tables), while defining a new subscription. Instead, use the option Map to existing tables. If this rule is violated, the subscription will not be created.
This restriction applies to all configurations, also with other DBMS products.
▪Row filtering
Row filtering (horizontal partitioning) is fully functional only if primary keys are defined on the source tables.
▪Dropping and re-creating tables when solidDB® is the source datastore
If you need to drop and re-create tables in subscriptions where solidDB® is the source datastore, you need to reconfigure the table mappings.