Hi Tom,

the only way to find associated volumes I know is to

select file_name, segment from contents where volume_name =
'<volume_to_reclaim>' and segment not in ('1/1')

this will give you the file_name of a file being spread over more than one
volumes
with this info you can

select volume_name from contents where file_name = '<path> <file_name>' and
 segment = ('_/2')

where segment is the counterpart of the segment found with the file_name
i.e. 2/2

But these SQL queries may require a significant amount of time to compute.

Maybe someone has a better idea to solve this?

Regards
     Mecki