Try this:
select volume_name from volumeusage where filespace_name="YOUR_FILE_SPACE"

Note:
Replace YOUR_FILE_SPACE with the filespace name you want to find out, must
be upper case. Use q filespace if you need to find exact spelling for the
filespace.

Example (Windows node name = pluto, filespace = e:):
select volume_name from volumeusage where filespace_name="\\PLUTO\E$"


Best regards,
Kolbeinn Josepsson





                      "Fc-Atm-Rck,
                      Tivoli (UNKNOWN)"         To:      ADSM-L AT VM.MARIST 
DOT EDU
                      <tivoli.fc-atm-rc         cc:
                      k AT LMCO DOT COM>               Subject: locating 
filespace
                      Sent by: "ADSM:
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      11.06.2002 22:15
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






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