MVSFORUMS.com

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

Hi All

We have 2 Regins in our DB2 systems we need to compare the the tables in the 2 regines are insync, if not we need to list out the table are not inSync How to check the same , can you gimme some idea about that

Thanks
Coolguy

kolusu · Posted: Thu Dec 07, 2006 7:33 am Post subject:

coolguy,

Please search before posting. check these links

http://www.mvsforums.com/helpboards/viewtopic.php?t=3528&highlight=table+compare

http://www.mvsforums.com/helpboards/viewtopic.php?t=4115&highlight=table+compare

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

Thanks Kolusu, I that example give very good idea abt the compare , But we want to compare the table structure only not data, Pls provide me the some idea about that Sorry for the confusion

Thanks
Cools guy

kolusu · Posted: Thu Dec 07, 2006 7:56 am Post subject:

coolguy,

once again please search before posting. check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=5820&highlight=table+structure+compare

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

Thanks Kolusu I saw that Post but we have around 100 table in our system do we have any Automated way thats what i want to know

Thanks
Cool

kolusu · Posted: Thu Dec 07, 2006 8:13 am Post subject:

coolguy,

wow . Did you expect something like "click my mouse and get a report" ? It is quite simple to repeat the query 100 times changing the table names. Good going keep it up

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

Thanks Kolusu Thanks for help and time