SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


IBM CDC data replication tool


IBM CDC data replication tool

Author
Message
Dale Hughes-356583
Dale Hughes-356583
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 203
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
jaiswalprash
jaiswalprash
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 3
Hi, We have just implemented IBM CDC on SQL Server. Please let me know what problems are you facing?Cheers, PJ
Ramangupta
Ramangupta
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 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.



chandra.arion
chandra.arion
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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.
phillia
phillia
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search