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

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.