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