As I can see, would consider two factors over the stgpool definitions:
.- reusedelay
.- threshold of lowmigracion
If you issue and expiration command and this don't working maybe you should
see if whether convenience change temporary the value for reusedelay
best regards
2014-04-15 8:59 GMT-0
and there were a lot of those.
I finally got the ksh to work.
This works - you don't need to escape at all: ' >= 65'!!!
Yup, if the equal sign is right after the gt sign then you
don't need to escape the gt sign.
Thanks!
Rick
From: Rhodes, Richard L.
Sent: Tuesday, April
sage
Regards,
Jim Schneider
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Michael Roesch
Sent: Tuesday, April 15, 2014 9:28 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] reclaimable tapes in a stgpool
Hi,
I'm using this query to see
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' orde
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% recla
If Primary Pool volumes are filling, they will not reclaim.
George Huebschman (George H.)
(301) 699-4013
(301) 875-1227 (Cell)
The contents of this email are the property of PNC. If it was not addressed to
you, you have no legal right to read it. If you think you received it in error,
please
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 \
