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
 

 

"Stack" data on a cart - monthly

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

Site Director


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

PostPosted: Fri Oct 09, 2009 3:02 am    Post subject: "Stack" data on a cart - monthly
Reply with quote

Some of the folks i work with have been given a new "opportunity" and have asked me for suggestions.

Currently, there is data (over 10,000 CYLs) they receive each month and for many years this has been copied to 3490 carts for long-term use (these are transaction history data and are periodically used to show all of the activity for a given account). Now, their boss has dictated that they must discontinue using 3490s and use "FAT" tapes (i don't know which model, but i don't believe this matters). They have also been directed to "stack" a year's worth of data on a single volume - this to save the cost of additional FAT volumes.

They asked about letting the disk files simply migrate and be recalled when needed and were told they cannot do this. Due to the volume of the data, they cannot use "virtual tape" either.

What would you suggest be done to "stack" a new month's files onto the same (or another) volume to join some number of previous month's data? Each January a new "stack" is going to be started.

The more i've thought about this, i don't recall there being a requirement to do exactly this anywhere i've been before.

One option i've thought about is to "toggle" between 2 volumes until year-end. Another consideration is that the dataset names have the year and month embedded in them.

My first recommendation was to simply use 1 FAT tape per month, but they said that was the first thing they suggested too and were told "no".

If this might be better served in some other part of the forum, it can surely be moved. . .

Thanks for your consideration and feedback,

d
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Fri Oct 09, 2009 10:54 am    Post subject:
Reply with quote

Hi Dick,

the way I would do it is when it's Jan, create a new FAT tape, no need to toggle between 2 volumes and depending on the month, you run the relevant step

Code:
//* JAN                                                 
//COPY#JAN EXEC PGM=SORT                                 
//SORTIN   DD DSN=input-dsn                             
//SORTOUT  DD DSN=output-dsn.D200901,                   
//            DISP=(,CATLG,DELETE),                     
//            UNIT=FATTAPE,                             
//            LABEL=RETPD=366                           
//SYSIN    DD *                                         
  SORT FIELDS=COPY                                       
/*                                                     
//* FEB                                                 
//COPY#FEB EXEC PGM=SORT                                 
//SORTIN   DD DSN=input-dsn                             
//SORTOUT  DD DSN=output-dsn.D200902,                   
//            DISP=(,CATLG,DELETE),LABEL=2,             
//            UNIT=FATTAPE,                                 
//            VOL=REF=output-dsn.D200901,               
//            LABEL=RETPD=366                           
//SYSIN    DD *                                             
  SORT FIELDS=COPY                                         
/*                                                         
//* MAR                                                     
//COPY#MAR EXEC PGM=SORT                                   
//SORTIN   DD DSN=input-dsn                                 
//SORTOUT  DD DSN=output-dsn.D200903,                       
//            DISP=(,CATLG,DELETE),LABEL=3,                 
//            UNIT=FATTAPE,                                   
//            VOL=REF=output-dsn.D200902,                   
//            LABEL=RETPD=366                               
//SYSIN    DD *                                             
  SORT FIELDS=COPY                                         
/*                                                         


The retention period is set for 1 year.

If you have a scheduling tool, it should not be too difficult to run the correct step based on which month of the year the job is running and build the correct date.

Gerry


Gerry
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Fri Oct 09, 2009 11:11 am    Post subject:
Reply with quote

Hi Dick,

for March the label should be 3
Code:
//            DISP=(,CATLG,DELETE),LABEL=3,     
Corrected the original

Gerry
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Oct 09, 2009 11:18 am    Post subject:
Reply with quote

I still prefer the HSM method. This is the scenario I employed for a similar situation where 9,000 cyls per month were created, and we had a legal requirement for 8 years retention. It depends on the requirements of data availability, but with the method below, it was belt, braces and thumbs in the belt loops.

1) A backup of each months data could be produced, according to MGMTCLAS, which offers additional security in case of media failure on the ML2 volume.
2) If there is media failure on the backup - then the backup can easily be recreated from ML2.
3) Even more secure is if the ML2 volumes are duplexed.
4) Using the MGMTCLAS for expiry, the tape usage released by dataset expiry can be reclaimed via RECYCLE.
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 Oct 09, 2009 8:13 pm    Post subject: Reply to: "Stack" data on a cart - monthly
Reply with quote

Thanks for the replies,

Quote:
no need to toggle between 2 volumes
Maybe i am overly cautious - if the single volume is somehow damaged in August, the first 7 months data would be lost. . . Due to the size, the transmitted input data is deleted when copied. . . The "sender" is not required to keep a copy once the incoming data has been validated/verified.

Quote:
I still prefer the HSM method
Me too icon_smile.gif Unfortunately, they have been directed to "roll their own", so i've been trying to think of something usable, but painless icon_wink.gif

d
Back to top
View user's profile Send private message
Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Sat Oct 10, 2009 7:43 pm    Post subject:
Reply with quote

If data loss is a concern, create two stacked copies each month rather than toggle. Still using only two tapes/year.
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: Sun Oct 11, 2009 3:03 am    Post subject: Reply to: "Stack" data on a cart - monthly
Reply with quote

Quote:
create two stacked copies each month rather than toggle
Thanks 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 Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 0 Mon Jan 02, 2017 11:16 am
No new posts JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am


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