This will do the trick

select distinct volume_name,node_name,filespace_name from -
  volumeusage where node_name = upper('$1') -
  and filespace_name = upper('$2') -
  and stgpool_name = upper('$3')





"Fc-Atm-Rck, Tivoli (UNKNOWN)" <tivoli.fc-atm-rck AT lmco DOT com> on 06/11/2002
11:15:52 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:  locating filespace



I would like to find out what tape volumes is a filespace is located on...
how can we do this?
Thank you.








**********************************************************************
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, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************