Is there a way to determine the number of tapes in a stgpool that
are eligible for reclamation?

I tried the following sql on all our TSM instances:
            select stgpool_name, \
                   count(*) \
              from volumes \
             where     pct_reclaim \> 64  \
                   and devclass_name like '%TAPE%' \
             group by stgpool_name "

It returned a list, but when I went and ran "reclaim stgpool  <name> 
threshold=65"
many of the pools returned that there were no volumes to be reclaimed.  I think
I need more qualifiers on the select.

We currently have reclamation running automatically with a
reclaim pct of 65% on the stgpool.  I'm trying to move to
manually running reclamation during a window.  I don't
want to just issue reclaim stgpool cmds all at once for all
instances to prevent a tape drive storm.  I want to start
them gradually, with the stgpools with the most tapes to be
reclaimed starting first.

Thanks

Rick






-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If
the reader of this message is not the intended recipient or an
agent responsible for delivering it to the intended recipient, you
are hereby notified that you have received this document in error
and that any review, dissemination, distribution, or copying of
this message is strictly prohibited. If you have received this
communication in error, please notify us immediately, and delete
the original message.