Have you tried:

show volumeusage xxxxxx

xxxxxx being the client node to restore.

This shows me all the tapes (volumes) that it would take to restore that
client node.

Thank You,
Bill Rosette
Data Center/IS/Papa Johns International
WWJD



                      David E Ehresman
                      <deehre01@LOUISVI        To:       ADSM-L AT VM.MARIST 
DOT EDU
                      LLE.EDU>                 cc:
                      Sent by: "ADSM:          Subject:  Re: DR test....issues
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      04/23/2003 11:53
                      AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






> No way to get full list of tapes
>needed for a restore that I know of.
>
Stick the following in a tsm script and invoke it as:
  run SCRIPTNAME NODENAME STGPOOL
and it will give you a superset of tapes that will be needed to restore
a node.  It lists all the volumes in a given storage pool that contain
data from the given node.

  select distinct volume_name,node_name from -
    volumeusage where node_name = upper('$1') -
     and stgpool_name = upper('$2')