TDP Exchange restores

[ja954]

Hi,
We are doing some TDP Exchange resotres but since our data is spread across multiple tapes I was wondering what's the most efficent way of getting the volume names of the tapes that we'd need to have inside our tape library? Does nayone have a SQL script to gather this data or is there a better way? Right now we kick off the restore and read through the TSM activity log and see what volumes can't be mounted.

JoeA

 

[THE_WIPET]

/*---------------------------------------------*/
/* Script Name: q_restore_tapes */
/* Description: This query will list the */
/* volsers required to restore */
/* a specific node */
/* run q_restore_tapes cdntdc1 prod_ca_windows */
/*---------------------------------------------*/
select distinct volume_name from volumeusage where node_name=upper('$1') and copy_type='BACKUP' and stgpool_name=upper('$2')


this should help you! But iI have no credit for the script... i've found it in the site... but cant remember who did it..

 

[JohanW]

Q NODEDATA <nodename> STGPOOL=<stgpool>

This gives you all XCHG TDP tapes, however, not just those you need for the backup.

 

[ja954]

Thanks to both of you.
The first script worked like a charm.

JoeA