Data Replication

  • 1.  Differential Refresh Question

    Posted Tue October 12, 2021 04:06 AM
    Edited by data icons Tue October 12, 2021 04:09 AM
    Hi, 

    Does anyone know if I were to perform Differential refresh on 1 table in a subscription, do the rest of the tables in the subscription continue mirroring based on their last applied bookmark or it will be using the new bookmark from the differential refresh? And also if I were to only perform log differences from differential refresh, will it's bookmark also skip to the latest?

    Any help is much appreciated. Thanks

    Environment Info:

    Oracle Database 19c Enterprise Edition Release
    IBM InfoSphere Data Replication 11.4

    ------------------------------
    data icons
    ------------------------------


  • 2.  RE: Differential Refresh Question

    Posted Tue October 12, 2021 09:50 AM
    Speaking for the IIDR CDC for z/OS product, when a refresh, either differential or standard, is performed, any mirroring  activity for the subscription is suspended after a final bookmark has been sent to the target.  Once the refresh has finished, the mirroring activity is restarted using the bookmark that was last sent.  If a differential refresh is used, and "Log Differences" is specified, the situation does not change.  Mirroring is not active while the refresh is ongoing.

    ------------------------------
    Mark Hodsman
    ------------------------------



  • 3.  RE: Differential Refresh Question

    Posted Wed October 13, 2021 12:06 AM
    Meaning to say that the bookmark for other suspended mirroring tables in the same subscription will be overwritten by the final bookmark obtained from the refresh?

    ------------------------------
    data icons
    ------------------------------



  • 4.  RE: Differential Refresh Question

    Posted Wed October 13, 2021 09:15 AM
    Bookmarks carry information for restarting a mirroring subscription.  They do not carry information about the tables in the subscription.  There are no bookmarks "... for other suspended mirroring tables in the same subscription ..." to be overwritten.

    ------------------------------
    Mark Hodsman
    ------------------------------