Re: How many tapes reclaimed by space reclamation?

Hello Rob,

         Here are two scripts I use. If you use these scripts, be sure you
do not put spaces in "pct_reclaim>=67". If you put a space by the ">"
character, it gets translated into a file re-direct statement if you run the
script on a DOS/Windows box command line admin.

           Al


Name           Line       Command

               Number
----------     ------
------------------------------------------------------------
RECLAIMCO-     10         select count(volume_name) as vaults from volumes
where
 UNT                       pct_reclaim>=67 and stgpool_name='COPYVAULT'

               20         select count(volume_name) as carts from volumes
where
                           pct_reclaim>=67 and stgpool_name='TAPEPOOL'

               30         select count(volume_name) as copydirs from volumes
where
                           pct_reclaim>=67 and
stgpool_name='COPY_DIRECTORIES'

Name           Line       Command

               Number
----------     ------
------------------------------------------------------------
SHOW_RECL-     10         select volume_name,stgpool_name,pct_reclaim from
volumes
 AIM                       where pct_reclaim>=67 order by
stgpool_name,pct_reclaim
                           desc


Alan Davenport
Senior Storage Administrator
Selective Insurance
alan.davenport AT selectvie DOT com
(973) 948-1306

-----Original Message-----
From: Rob Hefty [mailto:R.Hefty AT LABSAFETY DOT COM]
Sent: Wednesday, October 09, 2002 8:04 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: How many tapes reclaimed by space reclamation?


Hello all,

Does anyone have a script/SQL command to figure out how many tapes are below
the reclamation threshold?  I'm sure there has to be something easy, but
every command I've tried hasn't worked.

Thanks,

Rob Hefty
IS Operations
Lab Safety Supply