Capturing CDC logs into a table

nibumathewbabu · Post by **nibumathewbabu** » Thu Jan 25, 2018 8:39 am

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.

chulett · Post by **chulett** » Thu Jan 25, 2018 12:05 pm

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.

ray.wurlod · Post by **ray.wurlod** » Sun Jan 28, 2018 7:01 pm

Is the requirement actually to have CDC capture information from the transaction logs?

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Mon Jan 29, 2018 9:45 am

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.