Currently there is no support to perform differential refresh when source/target databases are DB2 for i (iSeries / IBM i)
This requires target tables to be cleared to perform a refresh in case there were any issues in replication.
We have production applications that read target tables 24x7 and a refresh requires application outages.
Since IDR CDC currently doesn't support this feature for DB2 for i, we cannot add critical tables to replication setup, instead we have custom SQL scripts to perform insert/update/delete after comparing source/target tables. It would be a major relief to do away with custom coding and add tables to a supported product.
Why is it useful?
|Who would benefit from this IDEA?|
How should it work?
|Customer Name||Penske Truck Leasing|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions