The fast refresh feature reduces the amount of time needed to replicate a large amount of data from the backend data server to the solidDB® server. The fast refresh is enabled by setting the IBM InfoSphere CDC for solidDB® system parameter solid_fast_refresh_on to 'true'. For further performance improvements, set the solid_fast_refresh_apply_pipes system parameter to match the number of processors (cores) in your system.
Before you begin
The fast refresh feature is applicable only in subscriptions where solidDB® database is the target datastore.
Most performance gains are achieved with simple setups; factors such as the amount of data per row per table, code page conversions, and column mappings will effect the performance of the fast refresh feature.
Fast refresh does not support the following IBM InfoSphere CDC functionality:
▪Conflict detection
▪Summarization
▪Row consolidation
▪Adaptive apply
▪User exits
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
1 Set the IBM InfoSphere CDC for solidDB® system parameter solid_fast_refresh_on to true (default is false).
For example:
dmset -I solidDB_1 solid_fast_refresh_on=true
2 Set the IBM InfoSphere CDC for solidDB® system parameter solid_fast_refresh_apply_pipes to match the number of processors (cores) in your system (default is 2).