Database connection pools shared by clones or multiple application servers

Technote (FAQ)
Problem
What is the database impact of sharing a datasource across multiple application servers or in a workload managed environment?
Solution
WebSphereŽ Application Server connection pooling enables administrators to establish a pool of database connections that can be shared by applications on an application server. Datasources and connection pools generally have a one-to-one relationship. However, in the case of a work load managed application, one pool is created for each clone or server group member.

A datasource creates one pool and has one max connections setting per application server. When implementing workload management, clones or server group members are considered separate application servers, meaning each clone or member of the server group has its own pool of connections to the database. The max database connections opened by that datasource would then be calculated as the number of application servers or clones that use the datasource multiplied by the number of max connections specified in the datasource properties.

This same concept applies when calculating the number of minimum connections established with the database.











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, DB Connections/Connection Pooling
Operating system(s): AIX, HPUX, Linux, Linux zSeries, Solaris, Windows
Software version: 3.5, 4.0
Software edition: Edition Independent
Reference #: 1111475
IBM Group: Software Group
Modified date: 2004-05-27