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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[email protected]> wrote on 2005-03-01 07:56:33: > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] 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 ([EMAIL PROTECTED]) > Berbee Information Networks > Office 262.521.5627
