The simplest way is to perform a dummy restoral and see what tape was
mounted. That takes a couple of minutes rather than days.
Another way is to correlate the file's backup date/time to mount times
as seen in the Activity Log, and then verify with Query Content, this
being all the easier where collocation is in use.

  Richard Sims

On Apr 15, 2005, at 6:26 AM, Jones, Eric J wrote:

Good Morning.
Running TSM Server 5.2.2 on an AIX 5.2 server.   The client take was
backed up was running TSM 5.2 on Win2K.
Is there an quick way to find what tapes a file is on.
We have to find a file that was deleted but need to find all the tapes
it was on.
We did a
"select * from contents where upper(node_name)="DCL02" and
upper(filespace_name)="\\DCL02\d$' and
upper(file_name)='\DATA\DATADIR\SHARE\ file_name.txt' > output.file"
The DB is about 28GB and the problem is it's been running for 11 days.
 All reclamation was stopped so the data would not move around.
Is there a faster way to determine what tapes a file is/was on?  I
realize it depends on the speed of the machine but it seems like a
rather long time.

Thanks
Have a Great Day,
Eric Jones

*  eric.j.jones AT lmco DOT com
*:   607-751-4133

Cell : 607-972-7621