When I started in my current role a few years back, first week on the job, I get a phone call
that ROBOT Alert detected close to full disk storage. I run a DSPJOBTBL and of course,
oops - almost full and storage % very much high.
First step, increase QMAXJOB value to 500000.
Next was to run a CLLE pgm that ran an SQL in the advanced job scheduler (Go JS)
that looks like this:
*************************************************************
PGM
RUNSQL ('CALL SYSTOOLS.DELETE_OLD_SPOOLED_FILES(DELETE_OLDER_THAN => CURRENT DATE - 30 DAYS, +
P_OUTPUT_QUEUE_LIBRARY_NAME => ''TESTLIB'', +
P_OUTPUT_QUEUE_NAME => ''TESTFILE'', +
PREVIEW => ''NO'')')
ENDPGM
*************************************************************
Note on the pgm:
This CLLE program can be run standalone and/or be added to the job
scheduler or your startup program. It's up to you to set the parameters.
Note the double quotes " " enclosing the library name, outq name and
preview value (NO = display what will be deleted, YES = the actual deletion).
Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Cell, Office and Text Messages: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com/
https://ermcopower.com/
IBM i Award Winning Blog Site:
https://ibmireference.blogspot.com/
Awarded IBM 2024/2025 Advocate, Contributor, Influencer and IBM i Ready Badges.
------------------------------
message: 3
date: Tue, 23 Dec 2025 17:34:11 +0000
from: Richard Schoen <richard@xxxxxxxxxxxxxxxxx>
subject: Keep Your IBMi System from Crashing Like Mine Did
Have you ever heard of the IBM i system job tables? If not you need to read this article to avoid your system from crashing like mine did.
https://github.com/richardschoen/howtostuff/blob/master/ibmi_system_job_tables_full.md
Keep those pipes clean.
Regards,
Richard Schoen
Web:
http://www.richardschoen.net/
Email: richard@xxxxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxxxx>
------------------------------
midrange.com
