Charles,
Here is a script that I run. It gives you about the same info and a
little more.
set sqldisplaymode wide
select cast (volumes.stgpool_name as varchar(10)) as TAPE_STORAGE_POOL, -
cast ((select library_name from devclasses where stgpools.devclass =
devclasses.devclass_name ) as varchar(9)
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, STGPO
On Apr 22, 2005, at 12:23 PM, Christopher Zahorak wrote:
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 -
"Hart, Charles" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
22/04/2005 11:57 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Calculating MaxScratch vs Allocate Volume
When I run the following slect
SELECT
58 AM
To: ADSM-L@VM.MARIST.EDU
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 = STGPO
st of my time playing around with the SQL queries..
Ben
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Mueller, Ken
Sent: Friday, April 22, 2005 10:20 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Calculating MaxScratch vs Allocate Volume
You should be
1
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Mueller, Ken
Sent: Friday, April 22, 2005 11:20 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Calculating MaxScratch vs Allocate Volume
You should be able to just add
This works for me:
select stgpools.stgpool_name,stgpools.maxscra-
tch, count(*) as "Num Volumes" from stgpools,
volumes where stgpools.stgpool_name=volumes.s-
tgpool_name and devclass='TAPE' group by
stgpools.stgpool_name,stgpools.maxscratch
order by stgpools.stgpool_name
At 10:57 AM 4/22/
