Re: Tuning tips for JDBC?

Marty,
if you have enough memory,
you could "TRY" to assing a separate pool with a reserved amount of memory.
This should remove the share of the *base pool.
But all should be seen at entire system level.

just my cent.

Urbanek, Marty wrote:

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

--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

--
-----------------------------------------------------------------------------
*** This messages was scanned for malicious contents ***
-----------------------------------------------------------------------------
Franco Biaggi
CH-6807 Taverne