DB2 Server has connection growing after idle time-out with DB2 Type II driver (ID 2082209/5022904)

After porting applications from another application server, physical connections are not being closed properly after the connections timing out. This problem is seen with the DB2 8.1.x version of the Client libraries (Type II) Driver against the same DB2 7.1.x Database Server.

Solution

Set the SteadyPoolSize and MaxPoolSize to the same number, and in addition, set the Idle Connection timeout also to 0 (zero). This disables the timing-out of idle connections and the user will have the full set of connections available.