Compare two tables with same structures in different servers
Moderators: chulett, rschirm, roy
Compare two tables with same structures in different servers
Hi,
As part of our testing phase, we would like to compare two tables with identical structures in two different servers.
Please suggest any optimal way of performing this using DS server edition.
Thanks in advance
Sue
As part of our testing phase, we would like to compare two tables with identical structures in two different servers.
Please suggest any optimal way of performing this using DS server edition.
Thanks in advance
Sue
Which part do you need help with? Just the comparison? I'd suggest using the CRC32 function to build a checksum over the data fields in each record and then see if the same key in the other file has the same checksum. If not, something is different between the two records.
If you are unfamiliar with checksums, an exact search here for CRC32 should help.
If you are unfamiliar with checksums, an exact search here for CRC32 should help.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi Sue,
you could use a job with a generic change data capture and runtime column propagation. The minimum information you need are the key columns for the comparison.
You will need generic stages with a sort and a hash operator preceding the input links of the generic cdc and you will need a solution to pass the tablename and key-columns to the job (Server-job with a function setting the UserStatus-variable?).
You can then run the comparison of all your tables within a Loop or use a more sophisticated control-structure to allow running some of these (multiple instance) jobs in parallel.
Consult the Advanced Parallel Job Developer Guide for reference on generic operators.
Sorry: this is not suitable for a Server only environment, of course.
you could use a job with a generic change data capture and runtime column propagation. The minimum information you need are the key columns for the comparison.
You will need generic stages with a sort and a hash operator preceding the input links of the generic cdc and you will need a solution to pass the tablename and key-columns to the job (Server-job with a function setting the UserStatus-variable?).
You can then run the comparison of all your tables within a Loop or use a more sophisticated control-structure to allow running some of these (multiple instance) jobs in parallel.
Consult the Advanced Parallel Job Developer Guide for reference on generic operators.
Sorry: this is not suitable for a Server only environment, of course.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is it possible for you to use parallel job? If so there may be easier methods involving Runtime Column Propagation and change detection stage types. You may be able to create just one job.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: