If you are using V3 you can do something like:

select  node_name as "Node",
        copy_type as "Copy type",
        filespace_name as "Filespace".
        stgpool_name as "STG pool",
        volume_name as "Volume"
from    volumeusage
where   node_name='putthenodenamehere'
and     stgpool_name='putthecopypoolhere'
and     filespace_name='putthefilespacenamehere'

and you will get a nice table output with the column headings given in the
first paragraph which is the pick list of tapes for the chosen node,
filespace and copypool.

I think this is neat.  If you use the V3 client as well you can get comma
separated elements and post process them however you want.

Regards, Sheelagh
------------------------------------------------------------------------------
Sheelagh Treweek                         Email: sheelagh.treweek AT oucs.ox.ac 
DOT uk
Sheelagh Treweek                         Email: sheelagh.treweek AT oucs.ox.ac 
DOT uk
Oxford University Computing Services     Tel:   +44 (0)1865 273205
13 Banbury Road, Oxford, OX2 6NN, UK     Fax:   +44 (0)1865 273275
------------------------------------------------------------------------------
> From owner-adsm-l AT VM.MARIST DOT EDU  Thu Apr  2 14:36:06 1998
> From owner-adsm-l AT VM.MARIST DOT EDU  Thu Apr  2 14:36:06 1998
> MIME-Version: 1.0
> Date: Wed, 1 Apr 1998 14:02:25 -0500
> From: "Roberts, Scott" <SRoberts AT ISI-MAIL.ISINET DOT COM>
> Subject: Re: Can I preview a restore of a filesystem
> To: ADSM-L AT VM.MARIST DOT EDU
>
> "SHOW VOLUMEUSAGE node" is almost what I need. If there was a way of
> limiting the
> output to report on a specific filespace (filesystem), that would be
> perfect. The problem I'm having is
> that the filespace I have to restore a spread amongst 55 8mm cartridges. My
> tape library
> can only hold 10 at a time. If I knew which volumes the filesystem
> (filespace) was on,
> I could load the library with just those volumes, or the first ten, then
> start the restore and go home.
> What I have to do now is wait for ADSM to tell me which volume to mount next
> as it's restoring.
> I believe LEGATO has such a feature.
>
> > -----Original Message-----
> > From: Jerry Lawson [SMTP:jlawson AT THEHARTFORD DOT COM]
> > Sent: Wednesday, April 01, 1998 7:49 AM
> > To:   ADSM-L AT VM.MARIST DOT EDU
> > Subject:      Can I preview a restore of a filesystem
> >
> > ---------------------------- Forwarded with Changes
> > ---------------------------
> > From: owner-adsm-l (INTERNET.OWNERAD) at SNADGATE
> > Priority: Urgent
> > Date: 3/31/98 11:42PM
> > To: Jerry Lawson at ASUPO
> > Subject: Can I preview a restore of a filesystem
> > --------------------------------------------------------------------------
> > -----
> > The following works on a V2 MVS server, so I would expect that it would
> > work
> > on an AIX one.... (but no guarantees) :-)>
> >
> > The only way that I know of to determine what tapes are needed is via an
> > undocumented command:
> >
> >      SHOW VOLUMEUSAGE node
> >
> > Beware, this is not a fast command - I suppose it depends on the size of
> > your
> > DB.  The command will show you which tapes a node is using.  It will only
> > include backups (not archive), and it is for all file systems.  It does
> > not
> > actually move any data, or ask for any mounts.
> >
> > There is no way that I am aware of to preload files from tape back to the
> > storage pool.  You could use the Move Data command, but that would take
> > all
> > of the files from the tape, so it is not very discriminating.
> >
> > Jerry Lawson
> > jlawson AT thehartford DOT com
> >
> >
> >
> >
> >
> > ______________________________ Forward Header
> > __________________________________
> > Subject: Can I preview a restore of a filesystem
> > Author:  owner-adsm-l (INTERNET.OWNERAD) at SNADGATE
> > Date:    3/31/98 11:42 PM
> >
> >
> > I will be restoring a filesystem which had been incrementally backed up
> > over
> > time
> > to an exabyte tape library unit. I would like to pre-load all the volumes
> > necessary for the
> > restore of a filesystem before starting the restore. Is there a way to
> > "preview" the restore
> > to determine which volumes will be needed ???
> >
> > Environment
> > AIX4.2
> > ADSM 2.1.12 (server)
> > ADSM 2.1.0.3 (client)
> > Exabyte has 10 slots, one drive and very slow and old.
>