First you need to find out what filespace it is assigned to.  If you
don't already know the filespace that it came from, this can be
identified by running the following select statement in the
administrative command line:

select filespace_name,hl_name,ll_name where node_name='NAME_OF_NODE' and
ll_name='V110260.1.000065S13M01.MI.16315970.Z'

This will identify the filespace name for you.  Make sure you use all
CAPS for the node_name as well as ll_name fields.  Next take that
filespace name and run the following select statement:

select filespace_name,volume_name from volumeusage where
node_name='NAME_OF_NODE' and filespace_name='NAME_OF_FILESPACE'

This will identify both onsite and offsite volumes that are assigned to
that filespace in particular.  Once again use all CAPS for boths fields.
Hope this helps.


Mel Dennis
Systems Engineer
Siemens Power Generation
Email:  melburn.dennis AT siemens DOT com


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Wednesday, April 19, 2006 2:52 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Select statement to find what tape a particular file
is on...

How would I be able to tell what onsite tape the following file is
located
on?  /n03/data/penv/merc/restored/V110260.1.000065s13m01.mi.16315970.Z

Someone is trying to restore this file and it keeps trying to go to the
offsite tape, but I do not see any reference to an onsite tape within
the
activity log, so I thought I would try to figure out what tape it is
on...
Any ideas?

Thanks in advance!

********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************