Re: Lots of QZDASOINIT jobs

On Jun 30, 2018, at 8:15 AM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

Concern over the number of QZDASOINIT Jobs seems to arise on a regular
basis from system administrators who have opened up the database server
ports and activated the database server jobs on their systems. But they
don't really have any control over how applications and how many
application clients may use those services. Once you've opened up the gate,
application developers control how and how much of those resources are
used. You should ask them.

On Fri, Jun 29, 2018 at 1:16 PM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

1. Yes, but how much is the question. If they're all idle, probably not
that big of deal. Why are that many would be my question. There should be
one for each active ODBC type connection. I guess you could have a lot of
clients, or maybe clients are leaving connections open and starting new
ones.
2. I seem to recall "Joblog Pending" means the job has ended but it's set
not to generate a joblog spooled file.



-----Original Message-----
From: James H. H. Lampert [mailto:jamesl@xxxxxxxxxxxxxxxxx]
Sent: Friday, June 29, 2018 12:25 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Lots of QZDASOINIT jobs

I've got a situation where there are lots and lots of QZDASOINIT jobs
(315 active, the last time I counted) running on a box. Along with
hundreds more that show up in a WRKJOB QZDAZOINIT as "Joblog Pending."

Two questions:

1. 315 active QZDASOINIT jobs sounds to me like it would be a drain on
system performance. Am I right?

2. I'm not entirely sure what "Joblog Pending" means (yes, even after
looking at the helptext, which doesn't really tell me anything that isn't
self-evident). They don't have spool files; what are they doing still in
the system at all?

--
JHHL

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD