The client GUI also contains an estimate function for the restore, that it
does not take into account tape access time.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-03-01
07:56:33:

> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
> Behalf Of JR Trimark
> >Does anyone know how to write a sql script that would display
> >how much data (active version only) would be restored for a
> >volume/drive?
>
> No, but there's a much easier way:
>
>    query filesp <nodename> <filespacename>
>
> and multiply pct_utilized by capacity. The SQL equivalent is:
>
> select filespace_name,pct_utilized,capacity from filespaces where
> node_name=<NODENAME>
>
> --
> Mark Stapleton (stapleton AT berbee DOT com)
> Berbee Information Networks
> Office 262.521.5627