Joni,
you could try adding " and filespace_name like '/root_vdm_4/%'"
david
----- Forwarded by David W Litten/Corp/DukePower on 06/13/2005 10:11 AM
-----
Joni Moyer
<[EMAIL PROTECTED]
ARK.COM> To
Sent by: "ADSM: [email protected]
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.edu> [ADSM-L] Filespaces on which
particular tapes?
06/13/2005 10:03
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.edu>
Hello,
I am trying to run a select statement that will find all of the tapes that
are being utilized by NAS_SERVER_2_OFFSITE (node_name) with the
filespace_name of /root_vdm_4/HMCH1015_* and it just will not run. I have
successfully run the following and received output, but I want to be able
to find particular tapes for a certain filespace. Any ideas? This is for
reporting on our NAS. The TSM server is at version 5.2.2.5 and is running
on an AIX os at version 5.2. Thanks!
Here is what I have run successfully:
select distinct volume_name,node_name from volumeusage where
node_name='NAS_SERVER_2_OFFSITE' order by volume_name,node_name
As soon as I place "and filespace_name='/root_vdm_4/*' within it it shows
no tapes
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]
********************************
