RE: Rein in QZDASOINIT

[Brian Piotrowski <bpiotrowski@xxxxxxxxxxxxxxx>]

Excellent!

Thanks to all who responded on this issue.

/b;

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of elehti@xxxxxxxxxxxxxxxxxx
Sent: Friday, January 23, 2009 3:31 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Rein in QZDASOINIT

Brian,
Building permanent indexes over frequently-used tables REALLY improved
the performance of our QZDASOINIT jobs. We have excellent, acceptable
response time now with QZDASOINIT and other jobs.

Years ago my attempt to limit the number of QZDASOINIT jobs allowed in
QUSRWRK subsystem was futile because new QZDASOINIT jobs simply spawned
into QSYSWRK subsystem after maxing out the number of jobs I imposed on
QUSRWRK subsystem.
I experimented with making changes to the parms to Prestart Job entries
and after much frustration, trial and error I settled on the settings
shown here.
Subsystem description:   QUSRWRK        Status:   ACTIVE

Program  . . . . . . . . . . . . . . . . . . . . :   QZDASOINIT
  Library  . . . . . . . . . . . . . . . . . . . :     QSYS
User profile . . . . . . . . . . . . . . . . . . :   QUSER
Job  . . . . . . . . . . . . . . . . . . . . . . :   QZDASOINIT
Job description  . . . . . . . . . . . . . . . . :   QDFTSVR
  Library  . . . . . . . . . . . . . . . . . . . :     QGPL
Start jobs . . . . . . . . . . . . . . . . . . . :   *YES
Initial number of jobs . . . . . . . . . . . . . :   5
Threshold  . . . . . . . . . . . . . . . . . . . :   1
Additional number of jobs  . . . . . . . . . . . :   2
Maximum number of jobs . . . . . . . . . . . . . :   *NOMAX
Maximum number of uses . . . . . . . . . . . . . :   100
Wait for job . . . . . . . . . . . . . . . . . . :   *YES
Pool identifier  . . . . . . . . . . . . . . . . :   2
Class  . . . . . . . . . . . . . . . . . . . . . :   QPWFSERVER
  Library  . . . . . . . . . . . . . . . . . . . :     QSYS
  Number of jobs to use class  . . . . . . . . . :     *CALC
Class  . . . . . . . . . . . . . . . . . . . . . :   *NONE
  Library  . . . . . . . . . . . . . . . . . . . :
  Number of jobs to use class  . . . . . . . . . :     *CALC
Thread resources affinity:
  Group  . . . . . . . . . . . . . . . . . . . . :   *SYSVAL
  Level  . . . . . . . . . . . . . . . . . . . . :
Resources affinity group . . . . . . . . . . . . :   *NO

////////////////////////////////////////////////////////////////////////
///////
Command DSPACTPJ SBS(QUSRWRK) PGM(QZDASOINIT)
shows that we peaked out at 47 jobs at some point since 12/08/2008.

DSPACTPJ SBS(QUSRWRK) PGM(QZDASOINIT)

Subsystem  . . . . . :   QUSRWRK         Reset date . . . . . :
12/08/08
Program  . . . . . . :   QZDASOINIT      Reset time . . . . . :
23:03:59
  Library  . . . . . :     QSYS          Elapsed time . . . . :
1095:17:14


Prestart jobs:

  Current number . . . . . . . . . . . . . . . . :   15

  Average number . . . . . . . . . . . . . . . . :   9.4

  Peak number  . . . . . . . . . . . . . . . . . :   49



Prestart jobs in use:

  Current number . . . . . . . . . . . . . . . . :   11

  Average number . . . . . . . . . . . . . . . . :   6.3

  Peak number  . . . . . . . . . . . . . . . . . :   47

Program start requests:
  Current number waiting . . . . . . . . . . . . :   0
  Average number waiting . . . . . . . . . . . . :   .0
  Peak number waiting  . . . . . . . . . . . . . :   1
  Average wait time  . . . . . . . . . . . . . . :   00:00:00.0
  Number accepted  . . . . . . . . . . . . . . . :   18405
  Number rejected  . . . . . . . . . . . . . . . :   0

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