RE: Rein in QZDASOINIT -- MIDRANGE-L

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