|
| 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. | |
| | |
| |
|
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
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|