Wanda

Try to download the article without success I have an IBM passport advantage 
but say not enough . It will be to much to ask  if you have the article to send 
it to me, I will really appreciate.

Thanks again, Regards
Robert
E-mail: rouzen AT univ.haifa.ac DOT il 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Prather, Wanda
Sent: Thursday, February 17, 2005 10:46 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Need a script

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