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