Instructions here:

http://www-01.ibm.com/support/docview.wss?uid=swg21114873


On Wed, Oct 7, 2009 at 2:18 PM, Brian G. Kunst <bkunst AT u.washington DOT 
edu>wrote:

> For security reasons, we're trying to identify what tapes a file is
> residing on.  I've found the object_id of the file we're looking for,
> 1524734887, and started a search of the CONTENTS table using the following
> sql command:
>
> SELECT * FROM CONTENTS WHERE NODE_NAME='UCSFSCL1_2' AND
> OBJECT_ID=1524734887 > /home/bkunst/qcontents.out
>
> This search has been running for over 24 hours now.  Is there a
> quicker/better way to search for the volume_id for this file?
>
> Thanks,
>
> --
> Brian Kunst
> Storage Administrator
> UW Technology
>