ADSM-L

Re: SQL query ??

1999-04-06 07:55:20
Subject: Re: SQL query ??
From: Trevor Foley <Trevor.Foley AT BANKERSTRUST.COM DOT AU>
Date: Tue, 6 Apr 1999 21:55:20 +1000
Can't you just work out how much active data there is from the filespace 
entries (filespace size and utilisation), and then extract that from the total 
amount of data stored for the tape pool?


Trevor

> -----Original Message-----
> From: Dick Nieuwenhuizen [SMTP:dnieuwen AT SOLAIR1.INTER.NL DOT NET]
> Sent: Tuesday, 6 April 1999 9:09 pm
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      SQL query ??
>
> Hi all,
>
> My management asked me too find out how much tapepool space is occupied
> by deleted and inactive files. I looked at the SQL Interface and tried
> some select commands, but I can't find how I can get the size of the
> files that are being backed up.
>
> Can someone help me with a SQL query that will display the size of
> deleted and inactive files, or any other solution to get this
> information.
>
> Thanks in advance
>
> Dick
<Prev in Thread] Current Thread [Next in Thread>