Cumulative Fixes for 4.0.7, 4.0.6 CM code
 Downloadable files
 
Abstract
WAS_CM_12-07-2004_4.0.7-4.0.6_cumulative_Fix; 4.0.7: Cumulative Fixes for CM code
 
Download Description
This Connection Pooling E-fix is cumulative WAS 4.0.6 and 4.07 AE

All previous non-custom Connection Pooling E-fixes are included in this Fix.

NOTE:
Cached Prepared Statements performance (PQ53331 and 115405) in 4.02 base

This code change features a performance increase to the WebSphere Connection prepared statement cache. The most benefit will be seen in the throughput of applications which use multiple connections simultaneously, although the performance for using a single connection is also improved.

The side effect of this improvement is that the semantics of 'Prepared Statement cache size' has changed. In previous versions this value signified the total maximum number of Prepared Statements (PS) that would be cached in the dataSource or Pool. In this E-Fix, the value still represents the number of PSs per dataSource, but the number is now divided by the number of connections. If the number of PS is less than the number of connections, a minimum of 1 per connection is allocated. For example given 100 PS, and 50 connections, you will have 2 per connection, and given 10 PS and 50 connections, you will have 1 per connection. Customers may wish to adjust the statement cache size. The default statement cache remains 100, and depending upon your connection pool size, this may be reasonable. For larger pool sizes, the statement cache size may need to be increased.

Statement cache size can be set using the Connection Pooling tab of the dataSource in the Admin Console.
 
Prerequisites
NONE
 
 
Installation instructions
Please review the readme.txt for detailed installation instructions.
 
URL LANGUAGE SIZE(Bytes)
Readme US English 23371
 
Download package
What is DD?
DOWNLOAD RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
WAS_CM_12-07-2004_4.0.7-4.0.6_cumul 5/2/2005 US English 1276978 FTP DD
 
Technical support
1-800-IBM-SERV (U.S. Only)
 
Problems (APARs) fixed
PQ98053 and previous
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): HP-UX
Software version: 4.0.7
Software edition:
Reference #: 4009573
IBM Group: Software Group
Modified date: May 4, 2005