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: [EMAIL PROTECTED]
<tivoli.fc-atm-rc cc:
[EMAIL PROTECTED]> 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.
