Home > IT Answers > AS/400 > In iSeries, System job tables nearing capacity. – How to reduce
harisudhan21
995 pts.
 In iSeries, System job tables nearing capacity. – How to reduce
AS/400 performance, iSeries System Log, OUTQ
The job tables are nearing capacity in our iSeries, we have purged some OUTQ's  as well, please could some one let u know any other house keeping methods?



Software/Hardware used:
as400 performance
ASKED: January 12, 2011  10:21 AM
UPDATED: January 18, 2011  9:53 PM
RELATED QUESTIONS
Answer Wiki:
As a start, use GO CLEANUP. Also try RCLSPLSTG. Good luck. DanF
Last Wiki Answer Submitted:  January 12, 2011  2:09 pm  by  DanTheDane   2,540 pts.
All Answer Wiki Contributors:  DanTheDane   2,540 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Save your QUTQ’s to tape with their spooled files. Deleted Old Spooled files from the system. Delete job logs.

HMSSL2K
 3,175 pts.
 

For background, run DSPJOBTBL. Then review the <help> text for Initial, Additional and Available job structures. The <help> text describes the relationships between those values and different system values that you might want to adjust.

Also, press ‘F11=In-use entries’ to see if ‘Pending’ joblogs might be a source of rising numbers of jobs.

How many jobs show in your system? What OS version/release are you running?

Tom

TomLiotta
 108,055 pts.
 

Enter command WRKUSRJOB QSECOFR if you find the job below

SRVMON0001 QSECOFR BATCH JOBLOG PENDING

The job number ranges 0001 to 0076, and there can be hundreds of them in joblog pending, simply delete them with option LOGLMT(0)

Abbo
 65 pts.
 

Apart from this do you regularly schedule IPL’s ?

pdraebel
 2,250 pts.
 

There’s a good 2-part article on this on the 400 Guru website:

Part one: http://www.itjungle.com/fhg/fhg092408-story03.html

Part two: http://www.itjungle.com/fhg/fhg100108-story03.html

Good luck!

EJFan
 40 pts.
 

The two IT Jungle articles mostly cover what can cover here if we get a little more info on where the excessive jobs are coming from.

There is a third article in the series — Admin Alert: When System Job Tables Attack, Part III. And that article links to a useful IBM Redpiece — Best Practices for Managing IBM i Jobs and Output (and a few other special tips).

We can provide sample code for some cleanup work if we are told what needs to be cleaned up. E.g., a utility to clear away “pending” joblogs might be appropriate.

Tom

TomLiotta
 108,055 pts.
 
HMSSL2K
 3,175 pts.