|
Component
|
System parameter
|
When to modify
|
|---|---|---|
|
IBM InfoSphere CDC for solidDB®
|
refresh_with_referential_integrity
|
If your subscriptions include tables with foreign keys, set refresh_with_referential_integrity in IBM InfoSphere CDC for solidDB® to true.
For more information, see Enabling use of foreign keys (referential integrity).
|
|
retrieve_credentials
|
If you are using SQL passthrough and your backend data server is DB2 for iSeries or DB2 for z/OS, set retrieve_credentials in IBM InfoSphere CDC for solidDB® to false.
|
|
|
solid_fast_refresh_on
solid_fast_refresh_apply_pipes
|
To enable the fast refresh for subscriptions where solidDB® is the source datastore, set solid_fast_refresh_on to true, and solid_fast_refresh_apply_pipes to match the number of processors (cores) in your system (default is 2).
For more information, see Enabling fast refresh.
|
|
|
IBM InfoSphere CDC for DB2 Linux, UNIX and Windows
|
refresh_al1ow_fast_loader
|
If your subscriptions include tables with foreign keys and your backend data server is DB2 for Linux, UNIX, and Windows, set the refresh_allow_fast_loader system parameter in IBM InfoSphere CDC for DB2 to false.
For more information, see Enabling use of foreign keys (referential integrity).
|
|
ddl_awareness
|
If you are using bidirectional replication and your backend data server is DB2 for Linux, UNIX, and Windows, set the ddl_awareness system parameter in IBM InfoSphere CDC for DB2 to false.
|
|
|
IBM InfoSphere CDC for Oracle
|
refresh_al1ow_fast_loader ts_fast_loader_disable_constraint
|
If your subscriptions include tables with foreign keys and your backend data server is Oracle, set the refresh_allow_fast_loader and ts_fast_loader_disable_constraint system parameters in IBM InfoSphere CDC for Oracle to false.
For more information, see Enabling use of foreign keys (referential integrity).
|