Firstly, with me struggling to spell DB2 let alone know the zparms by heart, is there not a way to set a different expiry date for each of the logs?
Failing that, IIRC (and it's been a few years, so the memory may be a bit hazy) expiry date/retention date doesn't quite work the same way for DASD as for Tape. Whereas expiry date on tape tells the tape management system to allow the tape to be 'scratched' and thus be used for other purposes, the expiry date on DASD is just the date the dataset can be written to (or deleted) without a WTOR being issued. If you were to set the retention period in zparms to 1 and then manage the datasets on DASD (via SMS Management Class or HSM Space Management etc.) to delete after four days then "Robert's your mother's brother" Cheers, Chris p.s. I like your shop with 4/1 days requirement for logs ... last time I dealt with this we had to keep the logs for 10 days on DASD, 180 on tape. Lots of fun when during upgrade activities, the applications decided to run it all through SQL ... cutting a new log every 3-5 minutes for 10 hours or so! -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Russell Witt Sent: Tuesday, 14 July 2009 11:40 AM To: IBM-MAIN@bama.ua.edu Subject: Re: Delete Tape Datasets Ron, But that is where your Tape Management System can come into play. All the Tape Management Systems have some type of "rules" (CA-1 calls it the RDS; CA TLMS calls it the RMF; and DFSMSrmm calls it Vital Records) that allow you to specify a retention rule or expiration date for tape files based on the DSN (and/or jobname combination). Simply create a rule in your Tape Management System to scratch these tapes after 1-day; problem solved. Russell Witt CA 1 L2 Support Manager -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu]on Behalf Of Ron Sent: Monday, July 13, 2009 10:05 AM To: IBM-MAIN@bama.ua.edu Subject: Re: Delete Tape Datasets Yes, but according to our DB2 DBA... we use dual logging, one set to tape, one set to DASD. He wants to keep the ones going to DASD for 4 days, but delete the tape ones after one day. There's a zparm... DSN6ARVP ARCRETN set to 4, which sets the retention to 4 days, but (excuse me for being a DB2 novice...) did not see anything in the DB2 manuals about setting retention for tape to 1 day andkeeping the DASD retention period to 4 days.... ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html