|
I have systems I manage with over 100 prestart jobs regularly, they are
controlled no differently that any other job.
Now if the SQL they use is problematic that's an application issue.
Jim Oberholtzer
Agile Technology Architects
On Jun 30, 2018, at 8:15 AM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:gate,
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
application developers control how and how much of those resources arewrote:
used. You should ask them.
On Fri, Jun 29, 2018 at 1:16 PM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
be
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
ofone for each active ODBC type connection. I guess you could have a lot
setclients, 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
isn'tnot 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
listself-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
listTo 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
To post a message email: MIDRANGE-L@xxxxxxxxxxxxquestions.
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
link: http://amzn.to/2dEadiD
Help support midrange.com by shopping at amazon.com with our affiliate
--
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.