Compare 2 tables from 2 different subsystems

sunibabi · New User Joined: 21 Apr 2005 Posts: 4 Location: swiss

Hello,

I need to compare a table (EMP_DTLS) located in subsystem DS1T (test region 1) with similar table located in subsystem DS2T (test region 2).

Could any one help me in this.

Thanks n Regards,
YS

socker_dad · Posted: Fri Apr 27, 2007 9:49 pm

I know there is a better way to do this, but I did it the hard way.

I used SPUFI to read the entire table. SPUFI creates a file userid.SPUFI.OUTPUT. I renamed this file to something a little more useful, like userid.environment1.TABLE.

Then I did it again with the other region and used SUPERC to compare the two.

Primitive, yes. Functional, yes. Tedious, oh yes. But it worked.

If there is a better way, please speak up!

sunibabi · New User Joined: 21 Apr 2005 Posts: 4 Location: swiss

Hi, thanks for the reply.... I too followed the same process. But I have more than 25 tables to compare.

Any simple solution/SQL????

PeD · Posted: Fri Apr 27, 2007 10:21 pm

EComp does that directly without unloading.

rajandhla · Posted: Mon Apr 30, 2007 10:29 am

Hi Ped,

Can you please elobrate on Ecomp.

Regards,
Jai

PeD · Posted: Mon Apr 30, 2007 11:56 am

EComp is a powerful mainframe compare software, historically built to satisfy the needs of IT people
in a large international bank, but extended afterwards.

It can compare ( and cross compare ) any kind of objects on mainframe : DB2 tables ( from same or different SSID ),
VSAM, SAM, data in MQSeries, data from SDSF, from SPUFI, from QMF, unlaod of tables , DDL's specific,
layout specific : stored in any kind of repositories : PDS, Panvalet, Changeman, SAM, etc

Great variety of criteria and options, clear results.

You can contact me offline to receive more documentation if you are really interested.

Best regards
Pierre