Rick,
We use a macro named count_reclaim.mac with these contents.
select stgpool_name,count(*) as Count from volumes where devclass_name in
('VIRTVOL','V3592-06','3592-06') and status='FULL' and pct_reclaim>=%1 group by
stgpool_name
For example, to run the macro if we were looking for 60% reclaimable space:
TSM> macro /path/count_reclaim.mac 60
Best wishes,
Keith
On Apr 15, 2014, at 9:59 AM, Rhodes, Richard L. 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.
|