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, -
10 maxscratch, -
15 numscratchused, -
20 cast(maxscratch-numscratchused as decimal(4,0)) as
"SCR_AVAIL" -
25 from stgpools -
30 where stgpool_name like '%VTL' -
35 order by devclass,stgpool_name
>>> "Lee, Gary D." <g...@bsu.edu> 4/6/2010 3:10 PM >>>
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.stgpool_name as "Storage Pool Name", -
a.devclass as "Device Class Name", -
count( b.volume_name) as " # VOLUMES", -
a.maxscratch as "volumes available" -
from stgpools a, volumes b -
where a.devclass <>'DISK' -
and a.devclass = b.devclass_name -
group by a.stgpool_name, a.devclass
--------- query ends. ------------
Thanks for any help.
Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310
