Try 
select volume_name , filespace_name  from volumeusage where
node_name='your_node_name' and filespace_name='your_req_filespace'
or
select volume_name,filespace_name from contents where
node_name='your_node_nmae' and  filespace_name='your_req_filespace'

Hope this help you,
suttinun pa-khanghung
Appication server system engineer
Shell Services International (Thailand)
suttinun.pakhanghung AT shell.co DOT th


> -----��ͤ����鹩�Ѻ-----
> �ҡ:    Dmitri Chilovich [SMTP:dmitrich AT US.IBM DOT COM]
> �������:     19 ���Ҥ� 1999 05:45
> �֧:    ADSM-L AT VM.MARIST DOT EDU
> ����ͧ:   Re: HELP / How can I generate a list of the tapes needed to
> restore an entire filespace ?
> 
> 
> I've already answered this question (do search for "volumeusage" ). Once
> again,
> we
> have standard command dsmadmc> q occupancy ....., it show us all
> filespaces and
> volumes occupied by
> each filespace. You can use "dsmadmc>select  * from OCCUPANCY where
> node_name=... filespace_name=... " also.
> To find the list of all tapes in library (including  tape volumes), do "q
> vol".
> To find the list of tape volumes, do "q libvol".
> To find a list of tape volumes outside of library (in cabinet) do "show
> volumeusage <nodename> filesp=<file
> spacename>"
> Now compare all these lists. You'll find all you need.
> 
> 
> Sincerely,
> Dmitri Chilovich
> ADSM Solutions
> __________________________________
> LN: Dmitri Chilovich/Raleigh/Contr/IBM
> E-mail: dmitrich AT us.ibm DOT com
> Office phone: 847-240 4654, internal 4654
> Pager: 800-946 4646 id 1473134
> ADSM USF: Dept.  XVCE, Mngr. Mrs Jane Harris/Raleigh/IBM
> IBM Schaumburg, 231 Martingale Rd, IL 60173
> ____________________________________________________
> Private Notes: Please, reply to dima_chilovitch AT hotmail DOT com