ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS REQUI



Help for IBM's record-oriented filesystem VSAM, ESDS, KSDS, RRDS, LDS and Storage management Subsystems

ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS REQUI

Postby rohpre » Thu Jun 28, 2012 11:30 pm

Hello All,

Please let me know your suggestions/advise for the following scenario I have.

I have a huge VSAM file say about atleast 500 million records. Most of these records are used only in certain conditions.
So iam planning to archieve these records prior to a particular date range onto a tape dataset ( Data prior to last one year will be archieved which contributes to atleast 70 % of the volume). But i might require these records under certain conditions in my processing. I can establish the requirement of these records in the process. But now I have problems on how efficiently I can bring back these from tape and use it in my process. ( I can use these back in a sequential or VSAM file). I have a major time constraint here on how quick I bring these records back from the tape. So my requirements are to bring these records quickly and efficiently and use it in my process with in a given time span. Im not aware if any special processing can be made on the tape files or any utilities available that can accomplish these.

Please let me know if any ideas or suggestions. Thank you in advance.
rohpre
 
Posts: 3
Joined: Wed Jun 27, 2012 3:57 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS REQUI

 

Re: ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS R

Postby Akatsukami » Thu Jun 28, 2012 11:49 pm

Perhaps you should also mention the kind of data set -- ESDS, RRDS, KSDS -- as this will of course make a major difference in recommendation.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS R

Postby rohpre » Thu Jun 28, 2012 11:55 pm

Hi,

its KSDS !!!
Thanks.
rohpre
 
Posts: 3
Joined: Wed Jun 27, 2012 3:57 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS R

Postby dick scherrer » Fri Jun 29, 2012 1:09 am

Hello,

When these offloaded records are needed, can the process be run from a sequential file or do they have to be reloaded kinto VSAM?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS R

Postby rohpre » Fri Jun 29, 2012 1:23 am

Hi,
These records can be either into a sequential or VSAM file - my only requirement being efficient and quick retrieval from tape.

Thanks,
rohpre
 
Posts: 3
Joined: Wed Jun 27, 2012 3:57 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS R

Postby dick scherrer » Fri Jun 29, 2012 1:43 am

Hello,

Suggest you speak with your storage management people about migrating these records directly to offline storage (they would need to be sequential records rather than a "dumped" copy of the VSAM file - i'd use your sort product as it should be quite a bit faster than IDCAMS REPRO.

Just naming the migrated file in a batch job will recall it to dasd - which should be rather quick. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS R

Postby NicC » Fri Jun 29, 2012 12:25 pm

If you use sort to create your output try and sort so that the records most likely to be used are near the beginning of the file.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: ARCHIEVE HUGE VSAM TO TAPE -ACCESS IT BACK-SUGGESTIONS R

Postby mongan » Fri Jun 29, 2012 1:28 pm

Why don't you split the file into several files, for example one file for each year? Then if no data is being accessed for a specific year the dataset will get migrated.
User avatar
mongan
 
Posts: 212
Joined: Tue Jan 11, 2011 8:32 pm
Has thanked: 1 time
Been thanked: 5 times


Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post