× 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.



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.





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.