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. "