reclaimable tapes in a stgpool

2014-04-15 Thread Rhodes, Richard L.
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 \

Re: reclaimable tapes in a stgpool

2014-04-15 Thread George Huebschman
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

Re: reclaimable tapes in a stgpool

2014-04-15 Thread Arbogast, Warren K
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%

Re: reclaimable tapes in a stgpool

2014-04-15 Thread Michael Roesch
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'

Re: reclaimable tapes in a stgpool

2014-04-15 Thread Schneider, Jim
| more rm $1.usage 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

Re: reclaimable tapes in a stgpool

2014-04-15 Thread Rhodes, Richard L.
: ' = 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 15, 2014 10:00 AM To: adsm-l mailing list (ADSM-L@VM.MARIST.EDU) Subject: reclaimable tapes in a stgpool Is there a way

Re: reclaimable tapes in a stgpool

2014-04-15 Thread Francisco Parrilla
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