Data Replication

 View Only
  • 1.  Troubleshooting Problem

    Posted Thu October 28, 2021 12:05 AM
    Hi people,

    I am having a problem with IBM InfoSphere Data Replication where subscriptions are in "Mirror Continuous" state but seems like nothing is being replicated to the target. Checked the TS_Bookmark table and the SCN seems to be running (decoded using dmdecodebookmark).

    Has anyone faced this before? Any input is much appreciated.

    Environment Info:

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

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


  • 2.  RE: Troubleshooting Problem

    Posted Thu October 28, 2021 02:03 AM
    Hello
    There are a number of possibilities
    1) The changes to be replicated have not yet been committed. CDC will only send transactions to the target once they are committed
    2) You have some row filtering in place which is not correctly specified  and is excluding data that should be replicated
    3) Target operations have been disabled by mistake
    4) Some product issue
    5) Large latency which means that changes you are expecting to see have not been replicated yet
    6) You have a RAC system and have configured a source datastore parameter which excludes some RAC nodes from the list of nodes whose log streams are to be processed - and the changes are on those excluded nodes

    You can review the scraper event log to see what logs are being processed. You can also run the dmshowlogdependency command on the source to see what logs are being scraped by the source and applied by the target

    I would also open up a case with IBM product support if you cannot find an obvious cause

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