I have a 3575 library also with TSM 3.7.4.0 server on AIX.  How are you 
dismountinmg your tapes?  We use the MOVE MEDIA command with the DAYS option to 
take aout tapes that haven't been accessed in say 8 days.   Reclamation then 
issues request for these tapes when needed to reclaim them or for another tape. 
 You have to monitor *SM server for REQUESTS with : Q REQ to see if it is 
requesting tapes from your OVERFLOW area.  Do you have an OVERFLOW area 
configured?

Note: when yopu move tapes with the MOVE MEDIA command out of library it 
changes the ACCESS to READONLY.  I simply do a:
q vol access=readonly
to see if any tapes there are EMPTY or have low utilization.



David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5525
david.longo AT health-first DOT org


>>> L.Mezera AT LABSAFETY DOT COM 06/29/01 11:02AM >>>
We are running TSM 4.1 and have a MagStar 3575 tape library.  Unfortunately,
we have had to dismount many of our private volume tapes due to increasing
storage needs (which will be resolved with the install of an additional tape
library next month).  It seems like the space reclamation process doesn't
ask for all of these dismounted private tapes after a certain time.

I would like to run a query of all tapes that the library knows about to see
the volumes that are below the threshold I want to have reclaimed.  I would
then like to compare these volumes to what is actually mounted in the
library.  We have been doing manual comparisons for the last few weeks and
this is very time consuming.  I am thinking we could do a SQL select
statement but I don't know what the syntax would be.

Basically, I want to do a Q VOLUME and look for any tapes that are below 40%
utilized and then compare the results to a Q LIBV 3575LIB command.  If I get
a hit in both queries, I want to know the tape number.  Any suggestions?

Thanks for your help.

Lu Ann Mezera
Data Center Supervisor
Lab Safety Supply
608-757-4909
608-757-4652 Fax
E-mail: l.mezera AT labsafety DOT com 
www.labsafety.com 



"MMS <health-first.org>" made the following
 annotations on 06/29/01 11:18:31
------------------------------------------------------------------------------
---
This message is for the named person's use only.  It may contain This message 
is for the named person's use only.  It may contain confidential, proprietary, 
or legally privileged information.  No confidentiality or privilege is waived 
or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard 
copies of it, and notify the sender.  You must not, directly or indirectly, 
use, disclose, distribute, print, or copy any part of this message if you are 
not the intended recipient.  Health First reserves the right to monitor all 
e-mail communications through its networks.  Any views or opinions expressed in 
this message are solely those of the individual sender, except (1) where the 
message states such views or opinions are on behalf of a particular entity;  
and (2) the sender is authorized by the entity to give such views or opinions.

==============================================================================