× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I guess I can try the RTVDIRINF data...

WITH T1 AS (
select d.QEZDIRIDX, D.QEZDIRNAM1, SUM(o.QEZALCSIZE) AS SIZE
from routines.qaezd0014d d left outer join routines.qaezd0014o o ON
D.QEZDIRIDX=O.QEZDIRIDX
WHERE D.QEZDIRNAM1<>'/'
GROUP BY D.QEZDIRIDX, D.QEZDIRNAM1
ORDER BY D.QEZDIRIDX, D.QEZDIRNAM1)
SELECT * FROM T1
ORDER BY SIZE DESC;

1945 /QSYS.LIB/QMPGDATA.LIB 67543113728
12413 /QIBM/UserData/OS400/MGTC/service 11233263616
3001 /QSYS.LIB/ROB.LIB 6498639872
17763 /fixes/group 4667908096
16859 /SAMETIME03/NOTES/DATA/Trace 4195962880

16754 /FTP/GDI/EQUIPMENTVENDORS/FROMGDI/GermanyAssyLine 3988856832

3107 /QSYS.LIB/ROUTINES.LIB/IFSLIST.FILE 2452234240
937 /QSYS.LIB 1961622528
...

I can refine it a little with a HAVING clause
WITH T1 AS (
select d.QEZDIRIDX, D.QEZDIRNAM1, SUM(o.QEZALCSIZE) AS SIZE
from routines.qaezd0014d d left outer join routines.qaezd0014o o ON
D.QEZDIRIDX=O.QEZDIRIDX
WHERE D.QEZDIRNAM1<>'/'
GROUP BY D.QEZDIRIDX, D.QEZDIRNAM1
HAVING SUM(O.QEZALCSIZE)>2000000000
ORDER BY D.QEZDIRIDX, D.QEZDIRNAM1)
SELECT * FROM T1
ORDER BY SIZE DESC;

1945 /QSYS.LIB/QMPGDATA.LIB 67543113728
12413 /QIBM/UserData/OS400/MGTC/service 11233263616
3001 /QSYS.LIB/ROB.LIB 6498639872
17763 /fixes/group 4667908096
16859 /SAMETIME03/NOTES/DATA/Trace 4195962880

16754 /FTP/GDI/EQUIPMENTVENDORS/FROMGDI/GermanyAssyLine 3988856832

3107 /QSYS.LIB/ROUTINES.LIB/IFSLIST.FILE 2452234240

and now for a little detail

WITH T1 AS (
select d.QEZDIRIDX, d.qezdirnam1, SUM(o.QEZALCSIZE) AS SIZE
from routines.qaezd0014d d left outer join routines.qaezd0014o o ON
D.QEZDIRIDX=O.QEZDIRIDX
WHERE D.QEZDIRNAM1<>'/'
GROUP BY D.QEZDIRIDX, D.QEZDIRNAM1
HAVING SUM(O.QEZALCSIZE)>2000000000
)
select t1.qezdirnam1,
o2.qezobjnam,o2.qezalcsize
from t1 left outer join routines.qaezd0014o o2
on t1.qezdiridx=o2.qezdiridx
where o2.qezalcsize>100000000
order by t1.qezdiridx, qezalcsize desc;

/QSYS.LIB/QMPGDATA.LIB Q145000025.MGTCOL 6763851776
/QSYS.LIB/QMPGDATA.LIB Q144000025.MGTCOL 6738685952
/QSYS.LIB/QMPGDATA.LIB Q143000024.MGTCOL 6694645760
/QSYS.LIB/QMPGDATA.LIB Q099000024.MGTCOL 6586642432
/QSYS.LIB/QMPGDATA.LIB Q147000025.MGTCOL 6465007616
/QSYS.LIB/QMPGDATA.LIB Q146000024.MGTCOL 6448230400
/QSYS.LIB/QMPGDATA.LIB Q142000024.MGTCOL 6409433088
/QSYS.LIB/QMPGDATA.LIB Q097000026.MGTCOL 6352809984
/QSYS.LIB/QMPGDATA.LIB Q098000024.MGTCOL 6331838464
/QSYS.LIB/QMPGDATA.LIB Q148000024.MGTCOL 1743990784
/QSYS.LIB/ROB.LIB Q099000024.FILE 1589665792
/QSYS.LIB/ROB.LIB Q097000026.FILE 1492148224
/QSYS.LIB/ROB.LIB Q098000024.FILE 1478516736
/QSYS.LIB/ROB.LIB Q100000025.FILE 957898752
/QSYS.LIB/ROB.LIB Q103000021.FILE 926048256
/QIBM/UserData/OS400/MGTC/service
Mc.216261.QYPSJSVR.QYPSJSVR.java.service.log 662700032
/QIBM/UserData/OS400/MGTC/service Mc.216261.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 531628032
/QIBM/UserData/OS400/MGTC/service
Mc.147767.QYPSJSVR.QYPSJSVR.java.service.log 325058560
/QIBM/UserData/OS400/MGTC/service
Mc.167707.QYPSJSVR.QYPSJSVR.java.service.log 308281344
/QIBM/UserData/OS400/MGTC/service
Mc.125338.QYPSJSVR.QYPSJSVR.java.service.log 300941312
/QIBM/UserData/OS400/MGTC/service
Mc.182920.QYPSJSVR.QYPSJSVR.java.service.log 296747008
/QIBM/UserData/OS400/MGTC/service Mc.167707.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 245366784
/QIBM/UserData/OS400/MGTC/service Mc.147767.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 226492416
/QIBM/UserData/OS400/MGTC/service
Mc.207508.QYPSJSVR.QYPSJSVR.java.service.log 219152384
/QIBM/UserData/OS400/MGTC/service Mc.125338.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 209715200
/QIBM/UserData/OS400/MGTC/service
Mc.215324.QYPSJSVR.QYPSJSVR.java.service.log 206569472
/QIBM/UserData/OS400/MGTC/service Mc.182920.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 206569472
/QIBM/UserData/OS400/MGTC/service Mc.215324.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 174063616
/QIBM/UserData/OS400/MGTC/service Mc.207508.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 173015040
/QIBM/UserData/OS400/MGTC/service
Mc.165255.QYPSJSVR.QYPSJSVR.java.service.log 162529280
/QIBM/UserData/OS400/MGTC/service
Mc.212234.QYPSJSVR.QYPSJSVR.java.service.log 161480704
/QIBM/UserData/OS400/MGTC/service
Mc.202009.QYPSJSVR.QYPSJSVR.java.service.log 161480704
/QIBM/UserData/OS400/MGTC/service
Mc.214414.QYPSJSVR.QYPSJSVR.java.service.log 160432128
/QIBM/UserData/OS400/MGTC/service
Mc.219419.QYPSJSVR.QYPSJSVR.java.service.log 160432128
/QIBM/UserData/OS400/MGTC/service
Mc.220339.QYPSJSVR.QYPSJSVR.java.service.log 160432128
/QIBM/UserData/OS400/MGTC/service
Mc.162750.QYPSJSVR.QYPSJSVR.java.service.log 160432128
/QIBM/UserData/OS400/MGTC/service
Mc.161861.QYPSJSVR.QYPSJSVR.java.service.log 160432128
/QIBM/UserData/OS400/MGTC/service
Mc.213492.QYPSJSVR.QYPSJSVR.java.service.log 160432128
/QIBM/UserData/OS400/MGTC/service
Mc.158375.QYPSJSVR.QYPSJSVR.java.service.log 149946368
/QIBM/UserData/OS400/MGTC/service
Mc.160966.QYPSJSVR.QYPSJSVR.java.service.log 143654912
/QIBM/UserData/OS400/MGTC/service
Mc.199310.QYPSJSVR.QYPSJSVR.java.service.log 143654912
/QIBM/UserData/OS400/MGTC/service Mc.212234.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 130023424
/QIBM/UserData/OS400/MGTC/service Mc.202009.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 130023424
/QIBM/UserData/OS400/MGTC/service Mc.214414.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 128974848
/QIBM/UserData/OS400/MGTC/service Mc.220339.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 128974848
/QIBM/UserData/OS400/MGTC/service Mc.165255.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 128974848
/QIBM/UserData/OS400/MGTC/service Mc.162750.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 128974848
/QIBM/UserData/OS400/MGTC/service Mc.161861.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 128974848
/QIBM/UserData/OS400/MGTC/service Mc.213492.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 128974848
/QIBM/UserData/OS400/MGTC/service Mc.219419.QYPSJSVR.QYPSJSVR.Management
Central.java.service.log 127926272
/QIBM/UserData/OS400/MGTC/service
Mc.135789.QYPSJSVR.QYPSJSVR.java.service.log 126877696

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.