a crude way is...for a single file...issue a restore to another filename and
watch
what tape mount gets called...you can also cancel the restore once the
mount is requested (q sess f=d...).
FYI

-----Original Message-----
From: Alexander Verkooijen [mailto:alex AT sara DOT nl]
Sent: Friday, August 30, 2002 9:56 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Tape a given file is on?


On 30-Aug-02 David E Ehresman wrote:

> Given a file that has been backed up by a node, how do I find out which
> tape the current copy of the file is on without doing a restore?

Ah, I would love to have SQL query that answered this question.
Obviously this information is in the database
somewhere otherwise TSM wouldn't know which
tape to mount when performing a restore.

But for some reason it isn't in the pseudo-tables the SQL
interface uses.

The CONTENTS table tells you which file is on
which tape but it doesn't tell whether the
file is the active version or not.

And the BACKUPS table holds information
about all the different versions of a file
but it doesn't tell you which tape it is on.

Very frustrating.

Regards,

Alexander
-----------------------------------------------
Alexander Verkooijen        (alexander AT sara DOT nl)
Senior Systems Programmer
SARA High Performance Computing