I use the mtlib command to display the tapevolumes currently in the
library and then "grep" out the entries that have the "scratch" number of
101 and then finally use the unix word count command -> "wc -l" to perform
the count for me.

mtlib -l /dev/lmcp0 -qI | grep 101 | wc -l


see the mtlib help files for clarification on above.

Chris.



Christopher S. Zahorak, BCS
Sr. AIX and Tivoli Administrator

University of Windsor
IT Services, Rm 203
401 Sunset Avenue
Windsor, Ontario
N9B 3P4
P: (519)253-3000 ext. 2762
F: (519)973-7083
email: chris AT uwindsor DOT ca




"Hart, Charles" <charles.hart AT MEDTRONIC DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
22/04/2005 11:57 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Calculating MaxScratch vs Allocate Volume






When I run the following slect

SELECT STGPOOLS.STGPOOL_NAME, STGPOOLS.MAXSCRATCH,
Count(STGPOOLS.MAXSCRATCH) as "Allocated_SCRATCH" FROM STGPOOLS
STGPOOLS, VOLUMES VOLUMES WHERE VOLUMES.STGPOOL_NAME =
STGPOOLS.STGPOOL_NAME AND ((STGPOOLS.DEVCLASS='3592TAPE')) GROUP BY
STGPOOLS.STGPOOL_NAME, STGPOOLS.MAXSCRATCH

I get the following out put

Server STGPOOL_NAME MAXSCRATCH
Allocated_SCRATCH
 MSPSTG3 TAPE_APP_BACKUP                                  20   58
 MSPSTG3 TAPE_ARCHIVE                                            40    30
 MSPSTG3 TAPE_ARCHIVE_COPY                               80    39
 MSPSTG3 TAPE_BACKUP_COPY                                250  193
 MSPSTG3 TAPE_DB_BACKUP                                  18    18



My question is how do I subtract "Allocated_SCRATCH Col from the
MaxScratch Col so I can see what the Acutal Scratch Remaining is.  The
plan is to have this be out put to a txt file that can be picked up by
our monitoring system so we can auto genertae a help desk ticket.  I
have searched around (here and the web) and can't seem to find a good
example.

Any insight would be great!!!!!!