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: [EMAIL PROTECTED] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Wednesday, April 19, 2006 2:52 PM To: ADSM-L@VM.MARIST.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 [EMAIL PROTECTED] ********************************
