Ask a question
Share on LinkedIn
A new capability that many DBAs have requested is now available in version 4.34 of the IBM Data Server Driver for JDBC and SQLJ, which is available with Db2 12.1.
Before version 4.34 of the IBM Data Server Driver for JDBC and SQLJ, automatic connection checking when an application released its connection to the connection pool was performed when the com.ibm.db2.jcc.DB2ConnectionPool.testConnectionOnCheckin property was set to true, regardless of whether sysplex workload balancing was enabled at the data server. Automatic connection checking in that environment could lead to excessive network activity and connection flooding.
Starting with version 4.34 of the driver, when sysplex workload balancing is enabled at the data server (property enableSysplexWLB is set to true), the following changed behaviors occur:
Automatic connection checking when an application releases its connection to the connection pool is disabled.
The driver always returns a value of true from java.sql.Connection.isValid.
These changes can prevent flooding of connections that require database access threads (DBATs) on Db2 for z/OS to perform automatic connection checking.
By
Jim Pickel
posted