Peter,
Here is a script you can run to find out how many tapes your client has data on.
You might not need to mount all of them as some will probably just contain
inactive data
/*  -----------------------------------------*/
/*  Script written 23/06/99 by John Naylor   */
/*  Script Name:  Q_TAPE_VOLS_TOT            */
/*  Description:Display total tapes for node */
/*  parameter $1 = node name
/*  Example:  run q_tape_vols havsd2         */
select node_name, count(distinct volume_name) -
 as "Tape total" -
 from volumeusage  -
 where node_name = upper('$1') -
 group by node_name

If you want to know the individual tapes then the script below will do that
/*  -----------------------------------------*/
/*  Script written 25/06/99 by John Naylor   */
/*  Script Name:  Q_TAPE_VOLS                */
/*  Description: Display the TAPES that      */
/*               relate to a specific node   */
/*  Parameter:   node name and storage pool  */
/*  Example:  run q_tape_vols havsd2 nwlcart */
select distinct volume_name,node_name from -
  volumeusage where node_name = upper('$1') -
  and stgpool_name = upper('$2')

If this is a test restore only,  then I would bin it and think seriously about
collocation for
your primary pools, or maybe regular backupsets.







Peter Koblauch <Peter_Koblauch AT MANULIFE DOT COM> on 01/05/2001 12:57:32 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  how to speed up NT restore?



Hello,

    I have been restoring  an NT client for about 8 hours now, a bare-metal
restore.
    The server is an RS/6000 at ADSM 3.10.
   The problem is that it until now only some MBs have been restored and
the client
    will need many GBs before it is done   ... Looks like this could take
days.

   The activity log and 'q session' shows that the restore session is doing
numerous
    ( DLT) tape mounts, and even when no mounts are outstanding very little
data is
   transferred from the server to the client. Looks like the data for this
client might be spread
   over hundreds of tapes. The storage pool for this client is not
collocated.

   Is there a way to speed up the restore?
   Would it make sense to do an "export node"  to tapes followed by an
"import node"  in order to force
   the data to fewer tapes or would I then just be spending time in the
"export" instead?
   Is there something else I can do?

--
any help would be appreciated!
any help would be appreciated!

  thanks,
    Peter Koblauch






**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group.
**********************************************************************