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
