Re: Lots of QZDASOINIT jobs

My fault here, I was thinking of QGYSERVER jobs.


Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #10 <https://www.bvstools.com/mailtool.html>: Resend
Emails - When emails are sent using MAILTOOL Plus or another addon, those
emails are logged and you have the ability to resend them one by one, or as
a batch (ie, all unsent emails at once).

On Sun, Jul 1, 2018 at 9:48 AM Bradley Stone <bvstone@xxxxxxxxx> wrote:

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