Data Replication

Expand all | Collapse all

CDC for Kafka - Refresh mode?

  • 1.  CDC for Kafka - Refresh mode?

    Posted Tue May 19, 2020 03:59 AM
    Hi, I am new to IBM CDC for Kafka, I want to clarify if it is available to set the replication method to "Refresh", not "Mirror".
    I tried it once but it failed - the subscription is locked and cannot be edited/changed.


  • 2.  RE: CDC for Kafka - Refresh mode?

    Posted Tue May 19, 2020 04:03 AM
    Hello

    Assuming you are logged in to the Access Server as a user with admin or sysadmin access you should be able to select the subscription and unlock it. Then you can change the replication method to refresh.

    However please keep the replication method and the replication status distinct. If you wish to mirror a table (replicate changes from the transaction log) but refresh a table again, then simply click on the table mapping in the configuration perspective and select flag for refresh

    Regards
    Robert

    ------------------------------
    Robert Philo
    ------------------------------



  • 3.  RE: CDC for Kafka - Refresh mode?

    Posted Tue May 19, 2020 04:23 AM
    Edited by Learner Cognos Tue May 19, 2020 11:25 AM
    Hi, so I can change the method of a table mapping from "Mirror" to "Refresh", right?
    Now I have a subscription, which is inactive, the table mappings' method is "Mirror" and status is "Refresh". It is ok to change the method to "Refresh"?
    I don't want the replication method to be Mirror.

    Update: I understand what you mean now, I can keep the method as Mirror, and then "flag for refresh" so that the status of table mapping is Refresh, then the subscription will start refresh before mirror.

    Really appreciate your help!

    ------------------------------
    Learner Cognos
    ------------------------------



  • 4.  RE: CDC for Kafka - Refresh mode?

    Posted Wed May 20, 2020 12:59 AM

    Hi, 

    if you set mirror please follow :
    1. method set to mirror 
    --> step 1 : choose change replication method >> mirror
    --> step 2 : set status flag for refresh (refresh) or mark capture point for mirroring (mirror)
    --> step 3 : start mirroring.

    hopefully solved this step

    thanks,
    richard



    ------------------------------
    Richard Richard
    ------------------------------



  • 5.  RE: CDC for Kafka - Refresh mode?

    Posted Tue May 19, 2020 04:04 AM
    Hi,

    please make sure for change replication method is "Mirror (Change Data Capture)

    hopefully solved your issue

    Thanks,
    Richard

    ------------------------------
    Richard Richard
    ------------------------------



  • 6.  RE: CDC for Kafka - Refresh mode?

    Posted Tue May 19, 2020 04:24 AM
    Edited by Learner Cognos Tue May 19, 2020 11:26 AM
    Hi, so the change replication method cannot be "Refresh"?

    Update: I understand now - I should keep the replication method as Mirror and change the status of table mapping to Refresh by "flag for refresh. Really appreciate your help :)!

    ------------------------------
    Learner Cognos
    ------------------------------