RE: Keep Your IBM i System from Crashing Like Mine Did

Nice.

The delete spool file thing is good.

However in my case it was the more nefarious one which is the joblogs in limbo which haven't ended or created an actual spool file. That's the *PENDING ones that get created by server jobs.

That's why you can't/shouldn't have QDFTSVR and other jobs using 4/00/*MSG or 4/00/*NOLIST. It causes the pending joblog conundrum.

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------

message: 3
date: Tue, 23 Dec 2025 19:32:38 +0000
from: Michael Mayer via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
subject: Keep Your IBM i System from Crashing Like Mine Did

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.