That's the ticket! Thanks everyone. I am also educating myself more on the
select command. It is new to me.
Also, using 'volumeusage' instead of 'volusage' works with show.
Thanks again!
Nancy Reeves
Technical Support, Wichita State University
[EMAIL PROTECTED]
Lawrence Clark <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
10/03/2000 08:08 AM
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Re: Tapes needed for a restore
Hi: The select mentioned previously work, except add a distinct after the
select to just show a volume once.........
adsm> select distinct node_name,volume_name,stgpool_name from volumeusage
where node_name='CLARKL'
NODE_NAME VOLUME_NAME STGPOOL_NAME
------------------ ------------------ ------------------
CLARKL 000169 NT3590BACK
CLARKL 000137 OFFSITEVOLS
CLARKL 000299 OFFSITEVOLS
Larry Clark
NYS Thruway Authority
>>> [EMAIL PROTECTED] 10/03/00 07:53AM >>>
Hi Nancy.....
There is a select statement that you can use, but normally gives a long
list of tapes(especially if you are not using collocation). This "query"
can be narrowed down if you know the filespace name linked with the
file/directory to be restored.
select volume_name,filespace_name from volumeusage where
node_name='UPPERCASE' and filespace_name='UPPERCASE'
Hopes this helps!
GOD Bless
Clarence Beukes
IT Specialist (Tivoli Certified)
Tivoli Storage Manager
IBM Intergrated Technology Services
Tel : +2711 302 6622 Fax : +2711 302 8806
Mobile : +27 82 745 3852
"A computer is almost human - except that it does not blame its mistakes
on
another computer. "
