I'm running an old DB2 V7.1 with Data Propagator.
One of those databases that I am replicating has around 400 tables and some of them very big (10 millions rows +) . After trying many times all choices and options I always get problems filling logs (or timing out). Tried ASNLOAD as apply option as I have heard could aliviate my logs to getting full but it locked some source tables and also got problems.
So I decided to trick Replicator by disabling all subscription to perform a full refresh and also update prncntl with binary zeros etc.
But I still confused.
1) Should I start capture cold or warm?
2) Before starting apply I will update pruncntl and then start it but what happen to the tables that get the message saying that a full refresh wasn't successful due my disable full refresh update? They will be keep capturing anyway (but not performing a full refresh)?
How can I solve this?
Thanks