Re: Is there a quick way to see what is filling up the disk?

[DrFranken <midrange@xxxxxxxxxxxx>]

One oops.

In the second SQL Below Files and Journal recievers are omitted. Delete 
that line to get everything.

        - Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 10/9/2019 5:10 PM, DrFranken wrote:
> For Temp Storage run this:
>
> SELECT bucket_current_size, bucket_peak_size,
>    RTRIM(job_number) CONCAT '/' CONCAT RTRIM(job_user_name) CONCAT '/'
>    CONCAT RTRIM(job_name) AS q_job_name
> FROM QSYS2.SYSTMPSTG
> ORDER BY bucket_current_size DESC;
>
> Find largest objects:
>
> SELECT objname, objtype, objattribute, objcreated, change_timestamp, 
> objsize
> FROM TABLE(QSYS2.OBJECT_STATISTICS('*ALL', '*ALL')) AS a
> where objtype not in ('*FILE', '*JRNRCV')
> order by objsize  desc;
>
>          - Larry "DrFranken" Bolhuis
>
> www.Frankeni.com
> www.iDevCloud.com - Personal Development IBM i timeshare service.
> www.iInTheCloud.com - Commercial IBM i Cloud Hosting.
>
> On 10/9/2019 9:59 AM, Tom Deskevich wrote:
> > We had one of those 'three mile island' situations, where the disk 
> > went from 58% to 98% quickly.
> > This is always someone internal causing this, not a customer.
> > So we checked active jobs and did not see anything that was running 
> > that was eating up the disk.
> > So possibly the job finished, and now we have a needle in the haystack 
> > situation.
> > I know you can do a RTVDSKINF but is there a quick way to see if there 
> > is a humongous file out there somewhere?
> > Even the new web based navigator does not show library size when you 
> > drill into IFS/QSYS.
> > Yes it could be something writing to a folder also. I see you can sort 
> > the root by size in navigator, that may help.
> > Thanks.
> >
> >
> > Harriscomputer
> >
> > Tom Deskevich
> > Programmer/Analyst
> >
> > P: 814-472-6066 x134
> > F: 814-472-5019
> > E: TDeskevich@xxxxxxxxxxxxxxxxxx
> >
> >
> > [cid:HLG_logo_14bd0fcf-3182-4b52-9120-a2e250d74b09.jpg]
> >
> >
> > 172 Gateway Road PO Box 568
> > Ebensburg, Pennsylvania
> > 15931
> > www.harrislocalgov.com<http://www.harrislocalgov.com>
> >
> >
> > This message has been sent on behalf of a company that is part of the 
> > Harris Operating Group of Constellation Software Inc.
> >
> > If you prefer not to be contacted by Harris Operating Group please 
> > notify us<http://subscribe.harriscomputer.com/>.
> >
> >
> >
> > This message is intended exclusively for the individual or entity to 
> > which it is addressed. This communication may contain information that 
> > is proprietary, privileged or confidential or otherwise legally exempt 
> > from disclosure. If you are not the named addressee, you are not 
> > authorized to read, print, retain, copy or disseminate this message or 
> > any part of it. If you have received this message in error, please 
> > notify the sender immediately by e-mail and delete all copies of the 
> > message.