DB2 Connect, JDBC, and Connection Pooling
Steve Mader
And if so, please point me to some sites that address any concerns
with doing this. Thanks!
Steve
Ollie
You came to the right place. What's the exact problem are you having?
Steve Mader
We're experiencing response time issues when our server is under usage
load. Our DBA is turning on DB2 Connect Agent Pooling for us tonight.
We are also developing a Java Connection pool for DB2 Connect
connections with in our JVM. The Java based pool will open the
connections to the database and hold them open for the entire day. My
question is: Should I be concerned with having these connections open
all day as apposed to closing them after each usage.
As I understand it, the Agent pooling in DB2 Connect keeps the
connections open (in a pool) from the DB2 Connect client to the DB2
Mainframe. The Java pool we're developing will keep the connection
open from Java Virtual Machine (the application) to the DB2 Connect
server on our local box (HP-UX). Java connection pooling is useful
under high loads because of the nature of the java.sql classes
(DriverManager.java's getConnection() method to be specific) and their
multi-thread safeness.
Any insight/experience that you can share is appreciated. Thanks!
Steve
boon seng
class and performance goal for the DDF transaction?
DB2 Connect communicate to DB2 server in the mainframe via the DDF.
We experience similar response time problem when the server is busy before
setting up DDF services class in WLM.
"Steve Mader" <steve...@eds.com> wrote in message
news:dc62e229.02102...@posting.google.com...