MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2014

RE: QZDASOINIT prestart job tuning



fixed

I think he might also want to check that he is using the IBM JDBC driver for linux. Other JDBC drivers may not work exactly the same as the IBM provided one.

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.apdv.java.doc%2Fdoc%2Ft0010264.htm

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Bipes
Sent: Wednesday, April 02, 2014 10:52 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: QZDASOINIT prestart job tuning

You just hit the nail on the head. Yes the programmer is using an application pool. Now for the funny part, the connections are all being used by other applications and servers so when his app runs in the morning, he has no available connections and it crashes. So since I am not a JAVA programmer and the programmer in question is not an iSeries programmer, how can we define the connection for a Red Hat Linux 6 server running Tomcat and a JAVA application? He is using a JDBC connection and when he gets in I will ask what tool kit he is using to establish the connection. I believe it is from the JT400 but I will not swear to it.

Chris Bipes
Director of Information Services
CrossCheck, Inc.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, April 02, 2014 7:40 AM
To: Midrange Systems Technical Discussion
Subject: Re: QZDASOINIT prestart job tuning

Chris,

I think you're missing something somewhere...

My understanding is that when a job is reused, it is reset. This should include the library list.

Sounds like you've got a connection pool on the app side that isn't actually releasing the job for reuse on the i side. Note that this also means that changing reuse to 1, won't have an effect.

And the connection pool isn't handling the differences in connection properties right.

I've heard of funny issues when you inadvertently have multiple layers of connections pools. For example, connection pools in a Java app itself along with another layer of connection pools in the application server.

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






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact