RE: Finding every savf in all libraries on the LPAR

Buck,
Now that's the cat's meow.

Object COUNT ( * ) SUM ( DIOBSZ )
Library
QGPL 1,069 23,103,938,560
CSRESTORE 135 5,111,648,256
IC08XXCHGP 132 2,121,719,808
ZENDSVR 37 1,572,147,200
KIMC 1 1,485,856,768
QCAEXP 16 801,234,944
COMDB200 8 684,417,024
QIWA2 8 658,497,536
QSYSDIR 15 571,109,376
PMR35885 2 555,864,064
QPRUV 2 490,979,328
SPYINSTALO 8 434,610,176
QJVM6064 109 419,459,072
IBM 2 411,353,088
PSINSTALL 7 397,905,920
CFPTCF 4 391,565,312
QICU 49 360,443,904
SPYINSTALL 1 335,228,928

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck Calabro
Sent: Friday, April 25, 2014 1:11 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Finding every savf in all libraries on the LPAR

On 4/25/2014 1:02 PM, Steinmetz, Paul wrote:

Thanks Larry that works too.
I don't use SQL often enough.
How about count and size totals, is that doable.

SELECT count(*), sum(diobsz)
FROM qusrsys/qaezdisk
WHERE diobat = 'SAVF'

If you want per library:

SELECT diobli, count(*), sum(diobsz)
FROM qusrsys/qaezdisk
WHERE diobat = 'SAVF'
group by diobli order by 3 desc

--buck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.