Hi all SQL gurus!

I am going to a disaster recovery shortly and I have the users asking if
there is any select statement or method to find all active files, what
tapes these files are on and the order that they are on the tape for each
client for the offsite tape copies.  Is this possible?  And if so, how
intensive is this on the server?  We have the tsm server running on os/390
2.10 at version 5.1.6.2 and this would be for Sun Solaris servers (a
majority of them are at the 4.2.1 client version).

If anyone has any suggestions for a way to do this or for a fast restore
process for disaster recovery I would appreciate it!  Thank you!

Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338