Re: QZDASOINIT jobs breeding like gerbils

[Alan Campin <alan0307d@xxxxxxxxx>]

QZDASOINIT jobs are pre-start jobs. The operating system starts them up so
it can start a job fast. How many it pre-start is based on subsystem
parameters. Also, if a job is set to re-use it will leave it hanging around
until it either times out or the job is re-used it's maximum times.

Do a dspsbsd on the subsystem and look for pre-start jobs and you will see
how many are pre-started and how many additional and how many times to
re-use.

On Thu, Jan 15, 2015 at 12:03 PM, Gary Thompson <gthompson@xxxxxxxxxxx>
wrote:

> Ok, let's say I have an excel workbook with an sql statement and I've got
> it open,
> I expect I've got a QZ job.
> Maybe my whole department has workbooks like that.
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> James H. H. Lampert
> Sent: Thursday, January 15, 2015 11:57 AM
> To: Midrange Systems Technical Discussion
> Subject: QZDASOINIT jobs breeding like gerbils
>
> I've just received a report of hundreds of active QZDASOINIT jobs hanging
> around on a customer box.
>
> I know that a QZDASOINIT job is an SQL server job, but why would there be
> hundreds of them hanging around like that? I haven't seen this behavior
> before.
>
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.