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
 

 

Need to compare 2 VSAM file through fileaid tool or any util

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
sandeep kumar302

New User


Joined: 14 Mar 2012
Posts: 69
Location: India

PostPosted: Wed Apr 09, 2014 2:50 pm    Post subject: Need to compare 2 VSAM file through fileaid tool or any util
Reply with quote

Hi,

I have a KSDS VSAM file with million of records. After the job has run some records say 50 to 100 new records in the VSAM file got inserted and 10 to 20 old records were modified( any field value got changed).

I have the backup of the original VSAM file ( before the job ran- another VSAM file with same data as backup) into a VSAM file.

My doubt is that how can i know the new records which got inserted in the file and the old records which got modified in the VSAM file.

Please let me know the procedure through Fileaid tool and what is the best way to achieve this. Is there any utility or tool apart from fileaid which can give me the desired result. Please help me on this.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Wed Apr 09, 2014 3:31 pm    Post subject:
Reply with quote

Please Google it with "file aid ksds compare" and pick the very first link, and that should give you what you asked for.
Back to top
View user's profile Send private message
TheMFKid

New User


Joined: 20 Nov 2013
Posts: 91
Location: India

PostPosted: Thu Apr 10, 2014 11:24 am    Post subject:
Reply with quote

You can write a job to unload(idcams repro) your VSAM files to temporary PS files and then use ISRSUPC(compare utility) in batch for comparing your both PS files.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Thu Apr 10, 2014 11:52 am    Post subject:
Reply with quote

Quote:
My doubt is that how can i know the new records which got inserted in the file and the old records which got modified in the VSAM file.


Is this a joke? You don't trust the update program?
Back to top
View user's profile Send private message
sandeep kumar302

New User


Joined: 14 Mar 2012
Posts: 69
Location: India

PostPosted: Thu Apr 10, 2014 2:20 pm    Post subject:
Reply with quote

hi Peter,
Actually i know that my program logicis workin fine but to be on safer side, i need to do the above verification for testing.

Thanks MFfid for your suggestions.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Apr 10, 2014 7:00 pm    Post subject:
Reply with quote

Hello,

Quote:
i need to do the above verification for testing.
Part of the promotion process in many organizatino includes this kind of verification.
If your files are large, suggest you use your sort product to "unload" the data.

Sort performs far better than idcams.

Depending on your specifics, you might consider a JOINKEYS to see the maintenance.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Thu Apr 10, 2014 7:09 pm    Post subject: Reply to: Need to compare 2 VSAM file through fileaid tool o
Reply with quote

Why unload the KSDS? Rohit found a link. Or use SORT with the KSDSs.
Back to top
View user's profile Send private message
sandeep kumar302

New User


Joined: 14 Mar 2012
Posts: 69
Location: India

PostPosted: Fri Apr 11, 2014 3:58 pm    Post subject:
Reply with quote

Thanks Bill and Dick,
Sort worked fine for me icon_smile.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Apr 11, 2014 6:55 pm    Post subject:
Reply with quote

Good to hear it is working - thank you for letting us know icon_smile.gif

d
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


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