Does this do what you want?
tsm: ULTSM>q script q_stgsum f=l
Name Line Command
Number
-- --
Q_STGSUM 1 select stgpool_name, -
5 devclass, -
10maxscratch
18 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Sql query help
There is a field in the stgpools table that shows how many tapes are used,
so I don't think you need a join.
select MAXSCRATCH, NUMSCRATCHUSED from stgpools
The way I monitor maxscratch is with this:
select STGPOOL_NAME,
.@bsu.edu
Sent by: ADSM-L@VM.MARIST.EDU
04/06/2010 03:10 PM
Please respond to
ADSM-L@VM.MARIST.EDU
To
ADSM-L
cc
Subject
[ADSM-L] Sql query help
Tsm server 5.5.4 running on suse 9 linux under zvm 5.3.
Trying to create a query which will give me the count of volumes in a
storage pool, and its
Tsm server 5.5.4 running on suse 9 linux under zvm 5.3.
Trying to create a query which will give me the count of volumes in a storage
pool, and its maxscratch setting on a single line.
Nice to watch for filling pools which need a larger maxscratch value.
Query follows:
---
select a
