On Tue, Aug 31, 2004 at 12:02:43PM -0400, James Lepre wrote:
> I am trying to find a statement that would allow me to see what tapes need to 
> be reclaimed.  Can this be done?
>

Depends ofcourse on your reclaimation level.. I have a few 'scripts' that
help me.  For example, if I want to see what tapes meet a particular
level in my offsitepool:

select volume_name, pct_reclaim from volumes where pct_reclaim >=$1 and -
stgpool_name='OFFSITEPOOL'

I can do run qreclaimf 80

And it will give me a list of tapes that are at or above 80% reclaimable.

Hope this helps.

bob