All,


The one thing I've always found to be a downside to TSM is the ability to
easily identify the EXACT amount of tapes required to rebuild an
environment to it's most current state. I have wrote SQL scripts
previously which performs a query against each TSM client and it's
filespaces for those files marked as "ACTIVE" and then linked to the tape
which held these files.

select distinct(con.volume_name) from contents con,backups bak where
concat(concat(bak.hl_name,' '),
bak.ll_name)=con.file_name and bak.state='ACTIVE_VERSION' and
con.node_name='STEGANOS' and con.type='Bkup'


The trouble with this query/script is that it took forever for it to run
and would not be much use during  a DR scenario.

Is there a simpler way to do this? Again, rather than recall all offsite
pool tapes, I only want the bare minimum to recover the systems to their
most recent state.


regards,

Rowan O'Donoghue
Technical Services Manager
Unitech Systems
Bracken Business Park
Bracken Road
Sandyford Industrial Estate
Dublin 18.

Tel:  + 353 - 1 - 2942300
Fax: + 353 - 1 - 2942319
www.unitech-ie.com