Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Compare 2 tables from 2 different subsystems

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sunibabi

New User


Joined: 21 Apr 2005
Posts: 4
Location: swiss

PostPosted: Fri Apr 27, 2007 8:11 pm    Post subject: Compare 2 tables from 2 different subsystems
Reply with quote

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
Back to top
View user's profile Send private message

socker_dad

Active User


Joined: 05 Dec 2006
Posts: 147
Location: Columbia, MO

PostPosted: Fri Apr 27, 2007 9:49 pm    Post subject: Re: Compare 2 tables from 2 different subsystems
Reply with quote

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!
Back to top
View user's profile Send private message
sunibabi

New User


Joined: 21 Apr 2005
Posts: 4
Location: swiss

PostPosted: Fri Apr 27, 2007 10:10 pm    Post subject: Re: Compare 2 tables from 2 different subsystems
Reply with quote

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

Any simple solution/SQL????
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Fri Apr 27, 2007 10:21 pm    Post subject:
Reply with quote

EComp does that directly without unloading.
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Mon Apr 30, 2007 10:29 am    Post subject: Re: Compare 2 tables from 2 different subsystems
Reply with quote

Hi Ped,

Can you please elobrate on Ecomp.

Regards,
Jai
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Mon Apr 30, 2007 11:56 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts compare 2 rows within the same file ram_vizag SYNCSORT 7 Wed Jun 14, 2017 12:34 am
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm
No new posts fuzzy compare Martylin JCL & VSAM 9 Thu Mar 30, 2017 2:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us