ADSM-L

[ADSM-L] Sql query help

2010-04-06 15:11:50
Subject: [ADSM-L] Sql query help
From: "Lee, Gary D." <GLEE AT BSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 6 Apr 2010 15:10:51 -0400
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

 
<Prev in Thread] Current Thread [Next in Thread>