Re: Select statement to find what tape a particular file is on...
Joni, Have a look at the CONTENTS table, as that includes volume names, node names and file names. Another approach that I'd suggest you follow first: check for any volumes or storage pools with access other than readwrite or readonly; any random access disk storage pool volumes that are offline; and any volumes where the error state is YES. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 04/19/2006 11:52:24: > How would I be able to tell what onsite tape the following file is located > on? /n03/data/penv/merc/restored/V110260.1.65s13m01.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] >
Re: Select statement to find what tape a particular file is on...
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.65S13M01.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.65s13m01.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]
Re: Select statement to find what tape a particular file is on...
The onsite tape is probably is not readable. Check to see if you have any volumes where access=unavailable. Orville L. Lantto Glasshouse Technologies, Inc. From: ADSM: Dist Stor Manager on behalf of Joni Moyer Sent: Wed 4/19/2006 1: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.65s13m01.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]
