IBM CDC data replication tool

  • Without getting into all of the politics of why I'm aksing this question, is there anyone out there using IBM's change data capture tool (CDC) for data replication connecting SQL Server instances? If I need to pursue this project, I'd like to know that I'm not first kid on the block to do it.

    Thanks in advance for your feedback.

    Dale

  • Hi, We have just implemented IBM CDC on SQL Server. Please let me know what problems are you facing?Cheers, PJ

  • We have implemented IBM CDC between multiple RDBMS systems Like Oracle, SQL and DB2 database.

    Where we have SQL is Source and Target and the same with other databases.

  • Hi All,

    I am new to IBM CDC, we implemented CDC with Informix as source and JMS messages and Oracle as target. We are replicating the data into Oracle and JMS messages to feed the ETL.

    We are trying to start the mirroring but is is failing all the time, the same subscriptions used to run earlier. There is no change but we exported the subscriptions and imported them back again.

    I have few questions, it would be great if anyone can help me out.

    1) Where to see the reason for the failure of replication?

    2) Where can we see the reason for why the subscription is inactive?

    3) What might be the possible cause for the failure of subscriptions?

    4) What steps do we need to take to debug the subscription.

    Also i can hardly find any trainers in the market for this.

    Please help me on the above and it would be great if anyone can train/support me.

    Appreciate all your help in advance.

    Thanks.

  • chandra.arion (3/16/2014)


    Hi All,

    1) Where to see the reason for the failure of replication?

    In the Management Console -> "Monitoring" tab -> highlight the subscription -> Select the "Events" button -> then "Retrieve Events"

    2) Where can we see the reason for why the subscription is inactive?

    In the Management Console -> "Monitoring" tab -> highlight the subscription -> Select the "Events" button -> then "Retrieve Events"

    3) What might be the possible cause for the failure of subscriptions?

    The Event log will give you the error information. With that we can figure out what is wrong.

    4) What steps do we need to take to debug the subscription.

    Start with the Events. After that, you can always turn on the trace. But, normally you will send the trace output to IBM, unless you know exactly what you are looking for in the trace.

    Also i can hardly find any trainers in the market for this.

    Please help me on the above and it would be great if anyone can train/support me.

    The best trainer I have found is the manuals and an test environment that I can play in. But then that is what I say about everything.... give me the book and let me play.

    If you post the event information, I will take a look and see what I can find. There are normally 1-3 messages where the "error" event is that will tell you exactly what is wrong. How to fix the issue may not be as obvious as what causes the error.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply