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