Jim Neal wrote:
>
>     The previous command that I gave you will work for this; however, you
> will want to reset the reclamation threshold back to 100 when you are done
> or the process will run automatically any time there is a tape that exceeds
> the threshold and you may or may not want it to run at that time depending
> upon which other processes are currently running and how many resources
> (tape drives) are already in use.
>
>    It is usually better to make this process part of a script that will run
> the housekeeping processes at specific times and in order.

That's the point of using the "reclaim stgpool" command instead of
monkeying with the storage pool settings daily.

Richard, you can use the "reclaim stgpool" command as you tried before.
But you need to specify a percent reclaimable threshold, not a percent
utilized value, and one low enough for there to be tapes with that much
or more reclaimable space on them.

Here's the pair of SQL select statements I use (in a server script which
takes storage pool name and percent reclaimable space as arguments) to
manually review the list of reclaimable tapes:

---cut---
/*
 * List volumes with space used and % reclaimable space
 * from storage pool $1 where more than $2 percent is reclaimable
 */

select volume_name, cast((est_capacity_mb * pct_utilized / 100) as int) -
  as "MB Used" , pct_reclaim from volumes where stgpool_name = upper('$1') -
  and pct_reclaim>=$2 order by pct_reclaim desc

select count(volume_name) as "Volumes with >=$2% reclaimable", -
  cast(sum(est_capacity_mb * pct_utilized / 100) as int) as "Total MB" -
  from volumes where stgpool_name = upper('$1') and pct_reclaim>=$2

---cut---


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Cheung, Richard
> Sent: Monday, November 10, 2008 3:48 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Re: reclamation
>
> Okay...  but either way, how does one then execute a manual reclamation
> process to get these tapes back at a certain threshold then?
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Jim Neal
> Sent: Tuesday, 11 November 2008 10:14 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Re: reclamation
>
> Hi Richard,
>
>     Percent utilized is not the same as percent reclaimable.  They're
> apples
> and oranges.  If you use pct_reclaim, you'll get what you want.  : )
>
>    Jim
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Cheung, Richard
> Sent: Monday, November 10, 2008 3:38 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Re: reclamation
>
> I am using a SQL query to query how many tapes to be reclaimed at a
> certain level
>
> Select count(*) from volumes where (stgpool_name='tapepool' and
> upper(status)='FULL' and pct_utilized < 99)
>
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> David Bronder
> Sent: Tuesday, 11 November 2008 9:57 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Re: reclamation
>
> Cheung, Richard wrote:
> >
> > Just to clarify - is that command going to permanently alter my
> stgpool
> > reclaim thresholds??   Or is that the command to do a manual
> > reclamation?  Why doesnt reclaim stgpool <tapepool> threshold=99 work?
>
> Jim's command alters the storage pool settings for reclamation (for
> the threshold and number of reclamation processes to run).
>
> I'd guess that your "reclaim stgpool" command isn't working because
> none of the volumes in that pool have 99% reclaimable space.  Your 86
> tapes that are 99% utilized may not have any reclaimable space, or
> may have some amount less than 99% reclaimable space.  In other words,
> percent utilized is not the same as percent reclaimable.
>
> You don't indicate how you consider a tape to be reclaimable.
>
>
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> > Jim Neal
> > Sent: Tuesday, 11 November 2008 9:33 AM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: [ADSM-L] reclamation
> >
> > Hi Richard,
> >
> >     I believe the command you want to use is:
> >
> > upd stg <tapepool> recl=99 reclaimpr=X (where x=number of reclaim
> > processes
> > to start).
> >
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> > Cheung, Richard
> > Sent: Monday, November 10, 2008 2:56 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: [ADSM-L] reclamation
> >
> > Hi..
> >
> > I have done some checks on my system on the Number of tapes to be
> > reclaimed in my main tape pool, and discover the following:
> >
> > No of tapes awaiting reclamation at > 99% utilized = 86
> > No of tapes awaiting reclamation at > 80% utilized = 51
> > No of tapes awaiting reclamation at > 70% utilized = 36
> > No of tapes awaiting reclamation at > 60% utilized = 23
> > No of tapes awaiting reclamation at > 50% utilized = 2
> >
> > To facilitate this, I thought I would do some manual reclamations to
> > clear the back log...
> >
> > However when I enter in
> >
> > Reclaim stgpool <tapepool> threshold=99 wait=no
> >
> > It tells me 'there is no data to be processed'
> >
> > Not sure why it would tell me that if there is supposedly 86 tapes at
> > 99%> pct util awaiting reclamation?
> >
> > Any one has any suggestions?
> >
> > Richard
> >


--
Hello World.                                    David Bronder - Systems Admin
Segmentation Fault                                     ITS-SPA, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bronder AT uiowa 
DOT edu