I think the both numbers should match, if didn't backuped anything at all after ran the first command...
On Thu, Apr 17, 2008 at 5:59 AM, Jeff White <[EMAIL PROTECTED]> wrote: > Hi > > > > TSM v5.4.0 > > > > I have a query regarding expiration > > > > Recently implemented new retention policies new reduce the amount of > version of windows files we have in TSM storage. Before implementing, i > ran this script to get the total number of files in storage at that > time: > > > > SELECT SUM(NUM_FILES), NODE_NAME FROM OCCUPANCY GROUP BY NODE_NAME order > by 1 desc > > > > This told me i had 125,171,962 files in storage > > > > I run expiry every day, capture and record from the activity log the > number of backup objects deleted every day. Over the first 10 days, this > totalled 6,652,218 files. > > > > I then re-ran the above script and the total number of files was > 113,796,651, a difference of 11,375,311. > > > > Was i wrong to expect number of expired files to match the actual > difference? > > > > > > Thanks > > > > Jeff > > > **************************************************************************** > Woolworths plc > Registered Office: 242 Marylebone Road, London NW1 6JL > Registered in England, Number 104206 > > This e-mail is only intended for the person(s) to whom it is addressed and > may contain confidential information. Unless stated to the contrary, any > opinions or comments are personal to the writer and do not represent the > official view of the company. If you have received this e-mail in error, > please notify us immediately by reply e-mail and then delete this message > from your system Please do not copy it or use it for any purposes, or > disclose its contents to any other person. Thank you for your > co-operation. > > **************************************************************************** > > ------------------------------------------------------------------------------------ > Email scanned for viruses and unwanted content by emailsystems > > Information regarding this service can be found at www.emailsystems.com -- __________________________________ Leandro Mazur