Re: Filespaces on which particular tapes?

Joni,

Try this script
/*  -----------------------------------------*/
/*  Script written 01/01/02 by John Naylor   */
/*  Script Name:  Q_TAPE_VOLS                */
/*  Description: Display the TAPES that      */
/*               relate to a specific node   */
/*               and filespace               */
/*  Parameter:   node name filespace name    */
/*               and storage pool            */
/*  Example:  run q_tape_vols testnode  testnode\data:  test9840   */
select distinct volume_name,node_name,filespace_name from -
  volumeusage where node_name = upper('$1') -
  and filespace_name = upper('$2') -
  and stgpool_name = upper('$3')




Joni Moyer <joni.moyer AT highmark DOT com>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
13/06/2005 15:03
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>


To
ADSM-L AT vm.marist DOT edu
cc

Subject
Filespaces on which particular tapes?






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
joni.moyer AT highmark DOT com
********************************



**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy Group.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission. Unless specifically stated otherwise, this
email (or any attachments to it) is not an offer capable of acceptance
or acceptance of an offer and it does not form part of a binding
contractual agreement.

Scottish Hydro-Electric, Southern Electric, SWALEC, S+S and SSE
Power Distribution are trading names of the Scottish and Southern Energy Group.
**********************************************************************