Query tape for restore

[dineshgoundar]

Hi Guys,

I have got to recover four servers. My TSM server is ready. How can I query the DB to find the tapes that I require to recover individual servers? I am recovering from Offsite Copy Pool. This is a DR test situation.

This is a windows environment with TSM 5.5

I have used this command: query nodedata <node_name> but this gives me a list of tapes out of which 50% are not in the Offsite Pool.

I remember seeing another query in this forum with something like "select xxx,xxx..." few days a ago and cant find that now.

* Note: I am new to TSM so detailed info would be appreciated.

Thanks
DG

 

[cjhood]

Try this:

select volume_name from volumeusage where node_name='NODENAME' and stgpool_name='OFFSITEPOOLNAME'

 

[dineshgoundar]

Thanks Chris,

It worked perfectly. Servers are restoring now. Thanks alot.

Much appreaciated