× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.