AFAIK, 

The only way you can do it is with a SHOW command.
If the file is stored in an aggregate, it's a 2-step process.

See www.ibm.com, search for technote 1166278.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Robert Ouzen
Sent: Thursday, February 17, 2005 11:45 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Need a script


Hi to all

 

Does anyone have a script to retrieve volume name on which a specific
file is (active and inactive file) I succeeded to retrieve the volume
name for specific nodename and filespace but I want to drill down to a
specific file.

Here is the script I use: 

 

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

 

T.I.A Regards

 

Robert Ouzen

E-mail: rouzen AT univ.haifa.ac DOT il