We have a JDBC connection to DB2 with the following configuration
Transaction Type: LOCAL_TRANSACTION
DataSource Class : COM.ibm.db2.jdbc.DB2DataSource
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10
Our DBA’s are complaining that web-methods server is keeping connection ideal. It seems the adapters is not releasing the connection once it is done. rather creating new connection there by maximizing the connection to the DB.
I have checked the ART package to the stats and it showed just 1 connection being used and 1 is busy. At same time DBA informed there were 300 are there and ideal. Is there any fix or a solution for this.