MVSFORUMS.com

arvibala · Beginner Joined: 12 Feb 2008 Posts: 142 Topics: 67

Hi,

I get a dump of data from a system and I need to load that onto VSAM file and start my process. I dont want to delete/define my VSAM cluster every time as it would use too many resources.

Can I just remove the existing data and load the VSAM with the new data from the Flat file usng simple JCL steps?

Thanks
Arvind B
_________________
Arvind
"You can make a difference with your smile. Have that with you always"

kolusu · Posted: Thu Sep 04, 2008 10:15 am Post subject:

arvibala,

Check this link

http://www.mvsforums.com/helpboards/viewtopic.php?p=9479#9479

expat · Posted: Fri Sep 05, 2008 1:29 am Post subject:

warp5 · Posted: Fri Sep 05, 2008 7:55 am Post subject:

And what kind of VSAM dataset is it? If it is a KSDS you should sort the data and what about CA splits and CI splits? You have to delete the old data which means that that has to be managed by VSAM as well. Probably the fastest way is to delete and define the dataset. I do not know who keeps coming up with sometimes absurd requirements. Take the time and test the different posibilities, you will learn a lot and probably be very surprised too.

arvibala · Beginner Joined: 12 Feb 2008 Posts: 142 Topics: 67

Yeah .. it is a KSDS.

The need for this is that the Vendor side maintains 2 tables and they say that they change the contents of the table every day and send us the DUMP in Flat Files. Because we need those data to process our daily routine we need the data in VSAM. And because we know that the data changes in VSAM, we need to have them deleted and have the new data loaded. And these happen daily. I think this can be done easily but I have do some homework, just wanna check if I can get some ideas from u all.

Kolusu, I did have a look at ur logic too, but I am expecting something much simpler. Maybe will work out something and post it here, if I find some.

Thanks,
_________________
Arvind
"You can make a difference with your smile. Have that with you always"

warp5 · Posted: Mon Sep 08, 2008 12:53 am Post subject:

I would say that there is no way around doing a delete and define of the cluster, which gives you a clean definition without CA and CI splits. Any other way will probably require more resources. Deleting the records requires that VSAM has to change indexing for each delete which is useless and a waste of resources if you are deleting all records anyway. Try testing both ways, I think you will be surprised how much more overhead you would have deleting the records compared to just deleting and defining the cluster.

arvibala · Beginner Joined: 12 Feb 2008 Posts: 142 Topics: 67

Thanks,

I am going with Delete/Define option
_________________
Arvind
"You can make a difference with your smile. Have that with you always"