Check your sys1.linklib for the program ADRDSUSU. It is part of the basic system and it is used in the CBPDO Installs.
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Eric Bielefeld Sent: Tuesday, September 23, 2008 11:17 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Scratching Expired Datasets This is in response to several replies. The datasets I want to expire are DB2 log files. They are on disk, and are just PS files. I also don't have ADRDSSU, which would make life very easy. Allan Stallar (I think) mentioned SuperScratch on the CBT tape. I found that, and will download it and see just what it does. Someone else mentioned using DCOLLECT to list the datasets, and then scratch the expired ones with Rexx. That is also a possibility. I think I have enough to go on now. Thanks for all the help. Eric ---- Terry Sambrooks <[EMAIL PROTECTED]> wrote: > Hi Eric, > > In respect of your question:- > > "Is there a way to scratch expired datasets without DFHSM or some other > storage manager? We create SMS datasets in DB2 that have an expiration date > automatically set. When the datasets expire, we want to scratch them." > > I will assume these are disk based data sets rather than cartridge based as > I would expect the Tape Management software to automatically return expired > cartridges to the scratch pool. > > In respect of disk based data sets I have two batch jobs in my daily > schedule which assist in tidying disk space. > > Non-DB2 Data Sets > > Any standard Sequential, Partitioned or VSAM data set is dealt with via > ADRDSSU run outside of DFHSM control. This actually uses last used data, but > looking at the manual the BY keyword does have an EXPDT option, so adapting > this process my help with these. > > DB2 Table Spaces > > All old DB2 Tables Spaces are removed from the system with the aid of a > batch REXX routine which invokes DB2 Services and executes appropriate SQL > statements to DROP the tables. > > Both of these techniques help to avoid volume pollution on my system. I hope > this is of use. > > Kind regards - Terry > > Terry Sambrooks > Director > KMS-IT Limited > 228 Abbeydale Road South > Dore, Sheffield, S17 3LA, UK > > Tel: +44 (0)114 262 0933 > WEB: www.legac-e.co.uk > -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] 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 [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
