Brian,
You should have a bunch of QZDASOINIT jobs running in QUSRWRK. If you
have one of those jobs consuming 60% of CPU for an extended period of
time, you need to look at the query being executed and find ways to make
that query run "better".
Each active QZDASOINIT job is handling "remote" SQL requests from one
connection. There can be inactive QZDASOINIT jobs that are waiting for a
connection. The connection can be ODBC or JDBC. They usually come from
an application running on a PC, but can come from java running on your
machine using the non-native JT400.
If you look at the job log of the QZDASOINIT job that is taking the huge
CPU slice, you can see the user that it is serving. Find that user and
see what he is doing. See if adding indexes or some other optimization
technique will improve the query and reduce the CPU utilization.
To answer your question directly, changing these values will NOT change
your CPU utilization. It'll just make the errant query take longer while
the CPU services other users. Changing the subsystem prestart values
takes place immediately, but it won't end any of the prestart jobs
currently running or prestarted.
Dan Kimmel
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian Piotrowski
Sent: Wednesday, December 16, 2009 12:42 PM
To: Midrange Systems Technical Discussion
Subject: QZDASOINIT prestart job entry Max Jobs and Uses
Hi All,
Even though we have changed the priority of the QZDASOINIT job, we are
still experiencing an abnormally large amount of CPU utilization (in
some instances in the neighborhood of 60% on average based on the
numbers reported by WRKACTJOB). After doing some poking around on the
Internet, I came across and article that discusses the prestart job
entry parameters for this job. The article mentioned reviewing the MAX
JOBS and USES values. Looking at our system, I see they are set to
*NOMAX and 200 respectively.
If I change these values, I am assuming I will be able to reclaim some
of this CPU utilization consumed by QZDASOINIT. The question is - what
is a reasonable number to set these values to so that I have a balance
of web pages being serviced in a timely manner without having the
QZDASOINIT job consume a large amount of resources?
Also - if I make changes to this job, do I need to IPL the machine, or
do I simply stop and restart the QUSRWRK subsystem (we are running
5.4.0)?
Any comments or suggestions would be most appreciated!
Thanks!
/b;
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Brian Piotrowski
Assistant Mgr. - I.T.
Simcoe Parts Service, Inc.
Ph: 705-435-7814 x343
Fx: 705-435-6746
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
http://www.simcoeparts.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
