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 ([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
