Hi Rebert,
  Thanks you very much for your recommendation. But it still not convenient
to me. Because I have more 50 volumes which related to the restoration node.
Some time more than 30 volumes are put out of library. It's not comfortable
to checkin all volumes of that node for restore which actually the number of
volume may be need 3-6 volumes for restoration. I ever use bmc and I'm very
appriciate to the dry run option. TSM should develop this one which I think
it is very useful for client.

Wira.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Robert Ouzen Ouzen
Sent: Wednesday, February 14, 2007 3:40 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] How to query the volume name when I need restore

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/>