WRKACTJOB should show you what you need to know. If not, try WRKSYSACT.
===================================
Also check WRKJOBQ to see if jobs are backed up in a single threaded JOBQ.
===================================
Also check with wrkdsksts or wrksyssts the DASD (if it is < 85% you can have a problem).
Take care with the queries that could be in a loop creating a huge spool file. Check the interactive activity (some users enjoy to run huge queries in interactive subsystem instead of submit to qbatch).
Good luck
Hector
Last Wiki Answer Submitted: January 24, 2009 4:23 am by mshen27,310 pts.
All Answer Wiki Contributors: mshen27,310 pts. ,
Teandy5,830 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
Actually, if you run the WRKACTJOB command you can press F4 on the CPU% column and it should put the job that is taking the highest CPU on your system. There might be more options if your using the iSeries Access program. I suggest you give it a try. Hope this helps.
WM, what version of operating system are you on? When I press F4 on the CPU% column from WRKACTJOB, all I get is an error message that states ‘Cannot prompt with cursor in this location’. Am I missing something here?
For starters, I would look at the WRKSYSSTS and ensure there are no jobs going ineligible. Secondly, I much prefer running with Auto-Performance Adjuster turned off. Proper tuning is important.
There is also WRKSYSACT, but you may have to have purchased performance tools for that to be on your system.
Once you have tuning resolved, there are some things you can do to help yourself.
For example, keep the machine tidy .. GO CLEANUP and use that to get rid of old logs etc. Journal Management etc is a little more of a manual effort, but they should be kept tidy…
Actually, if you run the WRKACTJOB command you can press F4 on the CPU% column and it should put the job that is taking the highest CPU on your system. There might be more options if your using the iSeries Access program. I suggest you give it a try. Hope this helps.
WM, what version of operating system are you on? When I press F4 on the CPU% column from WRKACTJOB, all I get is an error message that states ‘Cannot prompt with cursor in this location’. Am I missing something here?
Instead of F4, it should be F16 (upper shift of F4), to sort the jobs by CPU percentage.
There are so many places to look.
For starters, I would look at the WRKSYSSTS and ensure there are no jobs going ineligible. Secondly, I much prefer running with Auto-Performance Adjuster turned off. Proper tuning is important.
There is also WRKSYSACT, but you may have to have purchased performance tools for that to be on your system.
Once you have tuning resolved, there are some things you can do to help yourself.
For example, keep the machine tidy .. GO CLEANUP and use that to get rid of old logs etc. Journal Management etc is a little more of a manual effort, but they should be kept tidy…
Good luck. Holler if you wanna discuss offline.
Hi,
You don’t need performance tools to be able to use WRKSYSACT. I believe that you do need *JOBCTL authority.
Regards,
Martin Gilbert.