Hi All,
I have a requirement to capture the CDC logs (ie: number of copy rows, number of rows inserted, number of rows updated/deleted) in to a table. Is there any easy way to achieve this?
Please suggest options.
Capturing CDC logs into a table
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 22
- Joined: Thu Jul 05, 2012 5:09 am
- Location: Chennai
Capturing CDC logs into a table
Thanks
Nibu Mathew Babu
Nibu Mathew Babu
Why don't we start with some groundwork, some details of your requirement. Are we talking about database logs, say from a standby server or some other publish/subscribe CDC source or something else? Which database are you using? Are the logs currently being delivered to you and if so, how? Do you have the metadata for them?
I'd also be curious what, if anything, you've tried so far and what exact issues you are facing. At its most basic, getting something "into a table" should be pretty straight forward.
I'd also be curious what, if anything, you've tried so far and what exact issues you are facing. At its most basic, getting something "into a table" should be pretty straight forward.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What you are being asked to do is already performed by an IBM product that is integrated in DataStage:
InfoSphere Change Data Capture
https://www.ibm.com/support/knowledgece ... f_cdc.html
A good example of usage on DeveloperWorks is:
An efficient change data capture using IBM InfoSphere CDC Transaction Stage
https://www.ibm.com/developerworks/data ... index.html
And no - there is no easy way to do what that product does. To be truthful, I'm also not certain what the legal restrictions are on using CDC data without a license.
InfoSphere Change Data Capture
https://www.ibm.com/support/knowledgece ... f_cdc.html
A good example of usage on DeveloperWorks is:
An efficient change data capture using IBM InfoSphere CDC Transaction Stage
https://www.ibm.com/developerworks/data ... index.html
And no - there is no easy way to do what that product does. To be truthful, I'm also not certain what the legal restrictions are on using CDC data without a license.