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



We have a lot of JDBC connections to the iSeries due to people testing various 
parts of a large Java application. Sometimes there are hundreds of active 
QSQSRVR and QZDASOINIT jobs. This can be quite a load on the system. Response 
time increases dramatically, however WRKSYSSTS usually doesn't indicate that 
CPU or DB utilitization is extremely high. I sometimes see a lot of paging in 
the base pool when so many jobs are active, and I try to give it as much memory 
as possible.

Is there anything I can do at the system tuning level to improve our ability to 
handle all these JDBC connections? The JOBD has *NOLIST to eliminate the SPOOL 
files. 

The prestart entry for QZDASOINIT looks like: 

 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 . . . . . . . . . . . . . :   1         
 Threshold  . . . . . . . . . . . . . . . . . . . :   1         
 Additional number of jobs  . . . . . . . . . . . :   2         
 Maximum number of jobs . . . . . . . . . . . . . :   *NOMAX    
 Maximum number of uses . . . . . . . . . . . . . :   200       
 Wait for job . . . . . . . . . . . . . . . . . . :   *YES      
 Pool identifier  . . . . . . . . . . . . . . . . :   1         

Thanks,
-Marty


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.