Re: finding large objects on Iseries

[rob@xxxxxxxxx]

Joel,

I'm as big a fan of the system catalog files (QSYS2/SYS*) as the next 
fellow but there's nothing like that.  What I would recommend instead is 
to use RTVDSKINF and PRTDSKINF.  RTVDSKINF does take a long time. 
PRTDSKINF only takes a minute or two.  I have a job scheduler entry that 
runs that Wednesday night and I can review it Thursday morning.  The thing 
to remember is this is not your father's AS/400.  You're now running IBM 
i.  Instead of assuming that the space is eaten up by large db2 files, old 
spool files, etc IBM gives you that tool.

On the system below, if I deleted every single one of my PF's, what's the 
maximum space I could get back?
                                                % of         Size in 
Description                                     Disk     1,000,000 bytes
User libraries                                  1.78           41883.91 
User directories                               76.51         1797130.55 
Folders and documents                            .00                .11 
QSYS                                             .10            2449.36 
Other IBM libraries                              .36            8477.12 
Licensed Internal Code                           .20            4747.98 
Temporary space                                 1.11           26163.25 
Unused space                                   19.93          468143.53 
System internal objects                          .01             261.33 
Objects not in a library                         .00                .00 
TOTAL                                         100.00         2349257.14 

It would be like trying to fill a bucket with spit.  But, if however, it 
was significant there are other things you could do.  Like, 
PRTDSKINF *LIB.  This will tell you your biggest libraries.  And if you 
run PRTDSKINF RPTTYPE(*LIB) OBJ(*ALL) MINSIZE(10000) it will print out 
your biggest libraries and every object in that library over 10MB.  If you 
still want to know biggest objects regardless of library, then query the 
file created by RTVDSKINF (see F1 on RTVDSKINF to see the name of that 
file.  Sample:
select diobli, diobnm, diobtp, diobat, diobsz, dicdat, diudat
from qusrsys.qaezdisk
order by diobsz desc

Now, if odd ball stuff concerns you like spooling, etc it's all in the 
PRTDSKINF report.  Just further down into the details.

For more information on "User directories" see RTVDIRINF and PRTDIRINF.


Rob Berendt