|
View previous topic :: View next topic
|
| Author |
Message |
sandeep kumar302
New User
.jpg)
Joined: 14 Mar 2012
Posts: 81
Location: India
|
|
|
|
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 |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| 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 |
|
|
TheMFKid
New User
Joined: 20 Nov 2013
Posts: 91
Location: India
|
|
|
|
| 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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| 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 |
|
|
sandeep kumar302
New User
Joined: 14 Mar 2012
Posts: 81
Location: India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Why unload the KSDS? Rohit found a link. Or use SORT with the KSDSs. |
|
| Back to top |
|
|
sandeep kumar302
New User
Joined: 14 Mar 2012
Posts: 81
Location: India
|
|
|
|
Thanks Bill and Dick,
Sort worked fine for me  |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thank you for letting us know
d |
|
| Back to top |
|
|
|
|
