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.