The following is a reply from IBM when I had posed them the same question a
while ago.

James Louie
Nabisco

=======================================================
With ADSM Version 3,  SQL is your answer to this...  The following select
statements will get you pointed at the right place:

1) select * from syscat.tables where tabname='VOLUMEUSAGE'

This query will show you the different columns for the volume usage table.
Please note that the first column is node_name.

2) select * from volumeusage where node_name='XXX'

This will display the sequential media volumes in use for a given node...
The
volumeusage SQL table has all sorts of information (see the first select) so
there should be lots of uses for this.
========================================================

> On Monday, February 01, 1999 11:42 AM, Guntis Liepins
> [mailto:GLiepin1 AT EXCHANGE.TELEKOM DOT LV] wrote:
>
> Hi ADSM gurus!
>
> Is it posible to predict which tapes will be mounted during restore
> operation ?
> ( I need to make a list of tapes,to bring the tapes from the
> secure offsite
> archive,and
> load them into 3494 library)
> Currently ,the only way is to set library mountwait to 1
> sec,run the ADSM
> restore script
> file by file and watch in the actlog for the tape mount
> requests.  It is a
> _very_ slow way and this
> has a serios impact to the library (3494) operation and can cause some
> backup to fail
> during this operation. Btw,it seems that if file is split
> between two tapes
> error log will show
> me only the first tape.
> This way is ok if I need to restore a few files. But if I
> have a several
> thousands of files ,archived
> for several years,few thousands of tapes stored partially in
> the library and
> partially offsite
> this is a nightmare. ADSM must keep the information where the
> files are
> stored
> somewhere in his internal database,isn't it ? I simply *could* *not*
> *believe* that there are no
> smarter and easier way like to predict which tapes is
> necessary for restore.
> Please answer me - is it possible or not ?
>
> P.S. If the q content could display not only a filename ,but
> also an arhive
> description,it could be
> a solution. Unfortunately it can't do this.
>
>
> ------------------------------------------------------
> Guntis Liepins
>
> Systems administrator ,LATTELEKOM SIA
> tel. (+371) 7224199 mob. (+371) 9240376
> -------------------------------------------------------
>