i do not see my entry - maybe delay and duplicate entry
we are thinking about a disaster recovery DR scenario and export on regular basis, the ts_bookmark table
but now doing a test and deleted all rows from this table and the subs anyhow continues
shutting down the instance and deleting rows - also subs continue
looking at pointbase db : we see a table with source bookmarks
they are saved in internal db ? what is the purpose of ts_bookmark table ? it is not always keeping an entry for each subs and sometimes empty.
in case of dr, this table export will not help. we backup the pointbase db, but only once a day
and after restore, we are not in sync. what would be a good scenario to preserve to most recent bookmark as possible and avoid full refresh of all tables ?
the problem is that we replicate multiple src tables to 1 target and full refresh is not easy and we need consolidated one-to-one and diff refresh in case of refresh
another problem with this full refresh is : with db2 load command we can specify a modifier to change load behavior. can this be specified in system config somewhere, so that cdc full refresh would take this modifier into account ?
------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------
#DataIntegration#DataReplication