Use the select command like below. Lets say server to restore is TEST and
your offsite copypool is COPYPOOL.

select volume_name from volumeusage where node_name='TEST' and stgpool_name
='COPYPOOL'

I think I got the names right.

Thanks,
Robert Rippy.





From: "Lee, Gary D." <GLEE AT BSU DOT EDU> on 12/06/2002 10:20 AM

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

To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  getting list of offsite vols for restore

Had this happen again yesterday.

server 4.2.1
platform solaris 8
storage 3590-b drives in ibm 3494 library.

Issued the "restore volume" with wait=yes and preview=yes
Captured activity log, but when I did the restoer, it called for two other
volumes.  I really don't think I missed it.

Anyone have an idea or a script for determining needed offsite volumes for
a restore?

Thanks for the help.


Gary Lee
Senior Operating Systems Analyst
Ball State University
phone 765-285-1310