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:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 9:56 AM To: [EMAIL PROTECTED] 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 ([EMAIL PROTECTED]) Senior Systems Programmer SARA High Performance Computing
