There is a table in the database called volumeusage.  A sample output is
shown below.

adsm> SELECT * FROM VOLUMEUSAGE WHERE NODE_NAME='TSG_PDC'

     NODE_NAME: TSG_PDC
     COPY_TYPE: ARCHIVE
FILESPACE_NAME: \\tsg_pdc\d$
  STGPOOL_NAME: MFSERVICES_3494
   VOLUME_NAME: AA9172

To establish which volumes are used by a particular node and stgpool we use
something like the following.

adsm> select distinct volume_name from volumeusage where
node_name='PR005052A' AND STGPOOL_NAME='NHHDA_3494'


VOLUME_NAME
------------------
A11023
A11023
A11025
A11028
A11033
A11035
A11036
A11051
A11056

Hope this helps.

Richard.


=====================================
Technical Services (ADSM) - Dawson House
Int: 33298  Ext: 01925 233298
=====================================

> -----Original Message-----
> From: Kent J. Monthei [SMTP:Kent_J_Monthei AT SBPHRD DOT COM]
> Sent: 18 October 1999 22:51
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      HELP / How can I generate a list of the tapes needed to
> restore an entire filespace ?
>
> I'm running ADSM Server version 3.1.2.20 / ADSM Client 3.1.0.6.  I have a
> group
> of client nodes that share a common tapepool.    I lost an entire
> filespace on
> one of the nodes & now have to restore it.
>
> Each node backs up multiple partitions directly to the tapepool (primary
> pool)
> every night, and the tapes are sent off-site the following day, so all the
> tapes
> I need for the restore are off-site.  I can't afford the cost or time to
> wait
> for an ADSM restore session to iteratively prompt for the next tape
> volume, then
> go retrieve it from our off-site storage vendor.  I pay a fixed premium
> for each
> emergency tape delivery, regardless of the number of tapes delivered, plus
> there
> is a 2-hour minimum delay per delivery.  I need the ability to identify
> and
> recall all tapes that will be needed, before I initiate the restore.
>
> Does anyone know an SQL Select query (or any other way) to identify
> all/only
> those tapes needed to restore filespace X on node Y, either for all active
> files
> only (point-in-time 'now') or for a point-in-time Z ?
>
> -rsvp
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************