you could try " show voluse xxxx" where xxxx is the nodename of the client
you want to restore.  this would however, tell you every tape that this
client has data on. Which would be more then what you are looking for and
it sounds like you are not using co-location so your list would be quite
large.




"Gary Swanton" <kelly14 AT OPTUSHOME.COM DOT AU>@VM.MARIST.EDU> on 02/13/2002
04:01:39 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:  RESTORE VOLUMES

use
Hi All,

                I am quite new to all things TSM and I have a question
to what I believe is an unrealistic situation.

 Presently if, during my role as the TSM administrator I am asked to
perform a data restore, I have no idea of what volumes will be required
for the data.  I have a 30 slot library at my disposal, which I
appreciate is quite small, however, if after  I kick off a restore I
should have some indication as to what volumes are required thereby
allowing me to check the volumes into the library before the restore job
commences.

        A recent example:  I had to restore 80MB worth of data and it
took over 3.5 hours and over 18 tape changes.  The present situation is
that after I start a restore I have to be glued to the console and wait
for tape requests to appear in the activity log or via a pop-up.

        My research has shown that other people have been asking the
same thing as far back as 1998 but no-one appears to have provided a
solution.  Tivoli have told me that it is possible with some pretty
complex SQL statements.  Great now I have to learn SQL queries as well.

Does anybody have any ideas on this matter?  It's not that hard
surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with
current clients running 4.2.1.




Gary Swanton
Microsoft Certified Systems Engineer
kelly14 AT optushome.com DOT au