Hi Wira

Maybe this script will help you:

select node_name , volume_name, stgpool_name, filespace_name from volumeusage 
where node_name=upper('$1')

Say you name it: Restore_vol 

Run restore_vol nodename

Regards
Robert Ouzen
Haifa University
Israel

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Wira Chinwong
Sent: Wednesday, February 14, 2007 10:28 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] How to query the volume name when I need restore

Hi,
   I used TSM for long time. Until now I'm still feel bad every time
when I have to restore data especially when restore data from API (TDP
for oracle and backup image). The restore data size is very huge so they
need more than one volume to restore. Unfortunable I cannot maintain all
backup volumes in the library. So there are some volumes place out of
library. Every time I plan to setup restore schedule in the night but I
cannot reliably that the restore will be compeleted because I don't know
which volume should checked in before. Any idea please suggest.
 
Best Regards,
 
Wira Chinwong
Engineering Department Manager
 
SCSI Co., Ltd.   
719 KPN Tower Bldg., 11th Floor, Bangkapi, 
Huaykwang, Bangkok 10310
Tel 02-7171066-7  Fax 0-27171068
E-mail: wira AT scsi.co DOT th
<mailto:wira AT scsi.co DOT th>  
<http://www.scsi.co.th/>