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
|