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 <Jeff.White AT woolworths.co DOT uk>
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
|
