Number of DB2 Connections Restrictions on AIX
Subject: Number of DB2 Connections Restrictions on AIX
Created by Jocelyne Couturier on 10/10/2001 at 03:48 PM
I have a multi-threaded application that allocates a pool of 13 database connections. The database is B2 V7.1.0 on AIX. When executing the application remotely from VisualAge 3.5.3 running on Windows 2000, all connections succeed, however when executing on the server
where the database resides, the number of connections is restricted. With JRE 1.2.2, the number of connections is limited to 6. With JRE 1.30. the number of connections is limited to 3. In all cases JDBC2.0 is used and the same database is accessed. I've spoken to both DBA's and system support and no one knows the reason for this.
The error code is SQL1224N.
Does anyone know of these restrictions? Any help would be greatly appreciated.
Thank you, Jocelyne
[914 byte] By [
jcoutur] at [2007-9-26 9:22:23]
Hate to "me too", but I just discovered the same problem. I'm running Java v1.3.0 and DB2 version 7 on AIX. Whenever my application tries to make more than 2 simultaneous database connections, I get the error "SQL1224N A database agent could not be started to service a request".
Anyone find a way to get around this?
Thanks!
OK. I just found the answer. Talk about a harmonic convergence of things that have to line up to make your life miserable:
On AIX 4.3.3 or later, DB2 will issue SQL1224N and WebSphere administration server will fail with StaleConnectionException when attempting more than 10 local concurrent DB2 connections from a single process. JDK 1.1.8 allows a maximum number of 10 local concurrent DB2 connections. JDK 1.2.2 allows a maximum of 4 local connections. JDK 1.3.0 allows a maximum of 2 local connections.
http://www-1.ibm.com/support/docview.wss?rs=0&org=SW&doc=1009742
