Re: Lots of QZDASOINIT jobs

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