Change your "same" partitioning to partition by the key you are using. Also, change the setting for "Log Statistics" to True so you can see in the director what the stage sees as inserts or edits.
Could be that the files are truly not the same. From Unix do an md5sum on both just to be sure.
What kind of configuration file are you using?
This is about CDC stage
Moderators: chulett, rschirm, roy
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
Now I used "Auto" and "Hash" partions but I didnot find any difference in output.mhester wrote:Change your "same" partitioning to partition by the key you are using. Also, change the setting for "Log Statistics" to True so you can see in the director what the stage sees as inserts or edits.
Could be that the files are truly not the same. From Unix do an md5sum on both just to be sure.
What kind of configuration file are you using?
Change Mode = ExplicitKeys AllValues
What my expectation is output of ChangeCpture stage should be zero byte file
Can you please look into this and advise me
Thanks
Srini
Have you verified in Unix that the 2 files are the same?
Here are some things that I try when stuff like this happens -
Here are some things that I try when stuff like this happens -
- Change to a single node configuration (take partitioning out of the equation)
Ensure that column types are the same that are being compared
If using seq files and the expected results would be no output based on the properties defined, then I make sure the files are identical.
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The CDC stage is particularly for working with data captured from transaction logs by IBM's Change Data Capture product (formerly Data Mirror). Is this the purpose to which you are putting the stage? If not, investigate the Change Capture, Difference or Compare stages.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.