Thanks,  I will give it a try...

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Stapleton, Mark
Sent: Tuesday, April 27, 2004 2:27 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Locating files stored on tape_pools

From: ADSM: Dist Stor Manager on behalf of Barnes, Kenny
I currently had errors during reclaim for off-site copypool volumes
asking for files that cannot be found in on-site tape_pool volumes.
While searching for volumes with status of unavailable or destroyed, I
was able to find the volume.  This posed the question of, "if I had not
found tapes off-line, could I have determined what tape should have
contained the files using the file name?"  The errors in the actlog did
not specify the volume it was looking for. 

 
Not directly (at the file level anyway). However, what you could do is
run
 
select distinct volume_name from volumeusage where node_name=<node_name>
and filespace_name=<filespace_name>
 
This will give you a list of all volumes that contain data for that
node's given filespace(s). Eliminate the volume that are available, and
you can (hopefully) narrow down your search properly.
 
--
Mark Stapleton
--------------------------------------------------------------------------------------------------------------------------------------------------
Note:  The information contained in this message may be privileged and 
confidential
and protected from disclosure.  If the reader of this message is not the 
intended recipient,
or an employee or agent responsible for delivering this message to the intended 
recipient,
you are hereby notified that any dissemination, distribution or copying of this 
communication
is strictly prohibited.  If you have received this communication in error, 
please notify us 
immediately by replying to the message and deleting it from your computer.  
Thank you.
--------------------------------------------------------------------------------------------------------------------------------------------------