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