John, Please correct me if I'm wrong. select * from syscat.columns where tabname='BACKUPS' shows that there is a column called DEACTIVATE_DATE. I guess if you write a select statement crafted in such a way that it also takes into account current date, the management class (CLASS_NAME from BACKUPS) VERE/VERD/RETE/RETO, then you can conclude if the object is candidate for expiration.
Running such a select on a production machine is a whole other story. -- Warm regards, Michael Green On Tue, Apr 13, 2010 at 6:37 PM, John D. Schneider <john.schnei...@computercoachingcommunity.com> wrote: > Because of TSM's incremental backup scheme, there is no way to know what > files will expire, because their is no way to know what new versions of > files will be taking their place in the future. For example, say there > is a file called yoda.txt. If that yoda.txt file is backed up once and > is never changed, then the backup for it will never expire because the > backup of that file remains the "active" version of that file. If, > however, yoda.txt is changed from time to time, and a backup runs every > day, then the older versions of the file become "inactive" versions of > the file. Then the inactive versions will expire when they exceed > either the number of days or versions that you defined in the policy. > > So, when I backup yoda.txt today, there is no way to know when this > version of yoda.txt is going to expire, unless I have some way to know > how many new versions are going to replace it in the future. > > Can you tell us why you think it is necessary to predict what files will > be expired, or when? Since new backup data will be coming in > continuously, is it really important to know? > > Best Regards, > > John D. Schneider > The Computer Coaching Community, LLC > Office: (314) 635-5424 / Toll Free: (866) 796-9226 > Cell: (314) 750-8721 > > > > -------- Original Message -------- > Subject: [ADSM-L] Running a report on what files will expire in the > next sixty days > From: yoda woya <yodaw...@gmail.com> > Date: Tue, April 13, 2010 9:37 am > To: ADSM-L@VM.MARIST.EDU > > Is there a way to find the list of files/amount of data that will expire > in > the next 60 days? >