Hi,
I'm using this query to see all tapes and how much reclaimable space they
have in descending order. As we have a small library, this is suitable for
us.
SELECT
volume_name,devclass_name,stgpool_name,pct_reclaim,pct_utilized,status,access
FROM volumes WHERE devclass_name='LTO_DeviceClass' order by pct_reclaim desc
Regards,
Michael Roesch
On Tue, Apr 15, 2014 at 3:59 PM, Rhodes, Richard L. <
rrhodes AT firstenergycorp DOT com> wrote:
> 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.
>
|