fhg
Volume 6, Number 31 -- August 23, 2006

Joblogapalooza, Its Possible Causes, and a Call for Input

Published: August 23, 2006

Hey, Joe:

Last week the number of joblogs in our QEZJOBLOG output queue increased by thousands of spooled files. Auxiliary storage pool storage usage also increased from 74 percent to 96 percent. Even IBM can't tell me what's wrong. The only clues I have are that I keep getting a QSYSOPR CPF22E3 message that reads 'User profile EXPLOIT is disabled' and there are lots of QRWTSRVR joblogs in QEZJOBLOG. Do you have any idea what's happening?

--Laurent


I don't have a clear answer for what's going on but I do have a few suspicions. Here's what I think could be happening based on something that occurred in my shop last week.

We had a user job that was stuck in a loop as it was trying to write duplicate records with the same unique key. As the job kept processing, it literally created thousands of joblog files, all with multiple instances of the same CPF5026 error message (Duplicate Key Not Allowed for member &6). This job created so many joblogs that it eventually hit the upper limit on how many spooled files the system would let it produce. I later found out that a job's spooled file limit is defined in the Maximum spooled files system value, QMAXSPLF. My QMAXSPLF value was set very high at 20000 spooled files per job, and, sure enough, there were 21220 spooled files in my QEZJOBLOG output queue that day.

So in my case, the job blew the upper range on the number of spooled files that it could create. Because it was producing so many spooled files, it was slowly filling up storage but not so much storage that it threatened to crash the system as is happening in your situation. I'm not sure if your problem fits into this exact same scenario (where runaway jobs create excessive joblogs that are filling up system storage) but here are a few items to check for dealing with your own renegade spooled file situation.

1.  Check your QMAXSPLF system value to see how many spooled files a job is allowed to produce. The default value is 9999 (which is high enough, all by itself) but QMAXSPLF can be set anywhere from 9999 to 999999 spooled files per job in i5/OS V5R3. If this number is set too high, it's possible that a runaway job could be driving system storage upward with excessive joblogs. Correct QMAXSPLF as you see fit, but unfortunately IBM doesn't let you set this value below 9999.

2.  Check to see which devices or server jobs are trying to sign on to your system with the user profile. Investigate why you have a user profile called EXPLOIT and what type of processing the system uses it for. I find it curious that you keep getting CPF22E3 messages for that user (User profile &1 is disabled). It's possible there's a server job out there that's trying to sign on the system with the EXPLOIT user profile, and that the signons are being rejected because the profile is disabled. Maybe the job is being persistent in trying to log on and that could be causing the many thousands of QEZJOBLOG printouts that you are seeing (similar to what I saw when my looping job kept trying to add a duplicate key to a file, over and over again).

You can find any jobs associated with your EXPLOIT user by running the Work with User Job command (WRKUSRJOB) for that user profile, like this:

WRKUSRJOB USER(EXPLOIT)

In particular, check to see how many spooled files are associated with any jobs you find.

Another possibility is that someone could be trying to hack in to your system by using the EXPLOIT user profile and an automatic password guessing program. This may have caused EXPLOIT to be disabled according to the Maximum sign-on attempts allowed (QMAXSIGN) and the Action to take for failed signon attempts (QMAXSGNACN) system values. If it's an automatic attack, however, the program might be persistent and that may be why you keep seeing CPF22E3 messages in QSYSOPR.

Regardless of whether one of these scenarios is happening, I would also take a look at the QRWTSRVR server jobs on your system to see if they are trying to use EXPLOIT to perform redundant server processing. If EXPLOIT is disabled, the solution might be to simply re-enable the user profile.

3.  If the problem continues, be sure to clear QEZJOBLOG on a regular basis to keep excessive joblogs from overwhelming your system. Unfortunately, this is treating the symptoms rather than the cause but it may be what's needed to keep your system going until you find out what's wrong. You can clear QEZJOBLOG by using the following Clear Output Queue command (CLROUTQ):

CLROUTQ OUTQ(QEZJOBLOG)

So that's my possible take on the situation: it could be caused by a runaway job (or jobs) that with your system's blessings are producing too many joblogs. This may not be the answer you're looking for, but it seems odd that your shop came up with a problem that was eerily similar to what my shop experienced.

Beyond this diagnosis, I would also like to throw this question out to our Four Hundred Guru readers to see what they think. Since I have now encountered two situations where joblogs can start filling up the system, there may be more out there. If you have ever seen this situation occur before or you know how to solve it, please send me an email from the IT Jungle contact page. The best solutions may be featured in a future column.

--Joe


RELATED STORY

Making OS/400 User Profiles a Little More Secure



Sponsored By
CENTURIODB

Fast, easy, and free.*

With CenturioDB you can access directly external databases
(like Oracle, MySQL, MS SQL, DB2, etc.) from within your RPG or Cobol programs.

Fast, easy, and inexpensive.

*Summer promotion: The first three customers who order CenturioDB
before August 28th, 2006, get a free license!!!

Get a FREE Trial at: www.CenturioDB.com



Senior Technical Editor: Ted Holt
Technical Editors: Howard Arner, Joe Hertvik, Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Brian Kelly, Marc Logemann, David Morris
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

iTera:  High availability - Are you prepared in case of tornado? One customer is.
Patrick Townsend & Associates:  Alliance AES/400 - database field encryption
COMMON:  Join us at the Fall 2006 conference, September 17-21, in Miami Beach, Florida

 


 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement