I wonder why your restore is pulling tapes from "offsite" (I assume).  Are
the volumes coming out of a CopyPool?
If you are restoring files to a client, they would normally be restored
from the Primary Pool.

You could also do a select on the CONTENTS table for a particular file
name to find out what volumes it is on, BUT, that isn't going to show you
whether the file is Active or Inactive, or on what date it was backed up :

select volume_name, filespace_name, file_name, node_name from contents
where node_name='YOUR_NODE' and file_name in ('FILE001','FILE002',
'FILE06192015')

tsm: >select tabname, colname from syscat.columns where tabname='CONTENTS'

TABNAME                COLNAME
------------------     ------------------
CONTENTS               VOLUME_NAME
CONTENTS               NODE_NAME
CONTENTS               TYPE
CONTENTS               FILESPACE_NAME
CONTENTS               FILE_NAME
CONTENTS               AGGREGATED
CONTENTS               FILE_SIZE
CONTENTS               SEGMENT
CONTENTS               CACHED
CONTENTS               FILESPACE_ID


George Huebschman (George H.)



The contents of this email are the property of PNC. If it was not addressed to 
you, you have no legal right to read it. If you think you received it in error, 
please notify the sender. Do not forward or copy without permission of the 
sender. This message may be considered a commercial electronic message under 
Canadian law or this message may contain an advertisement of a product or 
service and thus may constitute a commercial electronic mail message under US 
law. You may unsubscribe at any time from receiving commercial electronic 
messages from PNC at http://pages.e.pnc.com/globalunsub/
PNC, 249 Fifth Avenue, Pittsburgh, PA 15222; pnc.com