> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of TSM_User
> Sent: donderdag 9 september 2004 3:59
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Select to find what tape a single file is on

> I know that when I use the TSM GUI to select a single file 
> for restore TSM determines what tape needs to be mounted in 
> seconds.  So, where is the table that helps link the file 
> requested for restore to the tape volume it is on.

The TSM client uses the real tables in the TSM database.
As you say, these tables obviously contain the information
that is needed to determine on which tape a specific version
of a file resides otherwise the client wouldn't be able
to do it's jobs.
Unfortunately the SQL interface doesn't provide access to
the real database tables but to 'pseudo tables' which don't
contain the information you seek.

Alexander

------------------------------------------------------------
Alexander Verkooijen
Senior Systems Programmer
High Performance Computing
SARA Computing & Networking Services