Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

IBM CDC data replication tool Expand / Collapse
Author
Message
Posted Wednesday, October 19, 2011 12:24 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 9:42 AM
Points: 13, Visits: 189
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
Post #1193123
Posted Monday, March 19, 2012 8:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 22, 2013 7:45 PM
Points: 4, Visits: 3
Hi, We have just implemented IBM CDC on SQL Server. Please let me know what problems are you facing?Cheers, PJ
Post #1269312
Posted Friday, April 13, 2012 2:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 28, 2014 8:42 AM
Points: 5, Visits: 191
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.



Post #1283443
Posted Sunday, March 16, 2014 3:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 17, 2014 8:25 AM
Points: 1, Visits: 6
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.
Post #1551598
Posted Tuesday, March 18, 2014 7:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 7:07 AM
Points: 1, Visits: 0
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.

Post #1552167
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse