× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. July 2018

Re: Lots of QZDASOINIT jobs

These jobs start from a host of different things. There's no worry about
them as far as I've seen. Killing them is like killing all your CGI jobs
that were started for your web servers so each new request requires the
start of a new job.

They're "helpers" used by APIs like DB access, listing spooled files, etc.

Bradley V. Stone
www.bvstools.com
Native IBM i e-Mail solutions for Microsoft Office 365, Gmail, or any Cloud
Provider!

On Sat, Jun 30, 2018 at 3:15 PM Nathan Andelin <nandelin@xxxxxxxxx> wrote:

Thanks for making that point, Jim. On the other hand, restraining
QZDASOINIT Jobs indiscriminately can be a source of frustration, as users
are blocked from getting to their data and running the services that they
have come to rely on.


On Sat, Jun 30, 2018 at 1:47 PM, Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

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:

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
--
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


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 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.