Daniel, here are some things you might try to account for your
discrepancies.
use mtlib to get a list of volumes & categories, then count how many tapes
are in each category
also use "select count(*) from volumes where location in
('VAULT','VAULTRETRIEVE','COURIERRETRIEVE',etc)
your select gets even onsite mountable drmedia
check to see if:
number of scratch tapes matches number of libvol scratch tapes
number of libvol private matches number of volumes in private category
Or you can do what I would do and use brute force. Use mtlib to get the
list of volumes in the library, grep and awk it to get just the volsers, put
it in a file (such as mtlibvols); then "dsmadmc q vol", grep and awk it to
get just the volsers, "dsmadmc q libvol status=scratch", again, grep and awk
it to get just volsers, cat the list of scratch to the list of vol to a file
(such as alladsmvols), then egrep -vf alladsmvols mtlibvols. That'll give
you volumes in the library that are not known to ADSM as vols or scratches.
Some might be dbbackups, but the rest will be stuff you'll probably need to
figure out, possibly exports or something weird like that. You can discount
dbbackups if you want to go through the extra step of "dsmadmc q drm", grep
and awk for only volsers, cat to alladsmvols, then "sort -un" it before
doing the egrep.
Good luck.
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
(503) 745-5091 fax
-----Original Message-----
From: Daniel Swan/TM [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 3:10 PM
To: [EMAIL PROTECTED]
Subject: Capacity figures not quite working out...why?
I've calculated my capacity as follows, but the numbers don't jibe. Here
are how I calculate.
1) Total offsite: select count(*) from drmedia
2) Total tapes: select count(*) from volumes where devclass_name='DEV3590'
3) Total Scratch: select count(*) from libvolumes where status ='Scratch'
4) # of tapes in library=(mtlib -l /dev/lmcp0 -qL | grep "number of cells")
minus (mtlib -l /dev/lmcp0 -qL | grep "available cells")
5) Number of tapes Onsite=total tapes-total offsite.
tapes in library should equal scratch+onsite, but it doesn't. Even giving a
little room for cleaning tapes. Here are how my figures work out:
1) 594
2) 1069
3) 183
4) 804 (857-53)
5) 475 (1069-594)
Now shouldn't 4) equal 5) + 3) ?? How do I account for the hundred
uncounted tapes?
How do I determine the # of tapes allocated for cleaning?
