PI61989: OPTIMIZE CONNECTION POOL BEHAVIOR WHEN THE FREE POOL DISTRIBUTION TABLE SIZE IS SET TO ONE

Fixes are available

APAR status

Closed as program error.

Error description

Default behavior in most cases calls for a connection pool to
hit it's max connections before attempting to reuse and
re-authenticate over existing matching connections.  This
avoids the overhead of searching the multiple hash tables that
organize the connections and prepping the connection for reuse.
But, when the free pool distribution table size is set to one,
this searching is not a concern and the overhead is mitigated
making it reasonable to reuse first, whenever possible, which
has the added benefit of a reduced memory foot print to handle
a given workload.

Local fix

Problem summary

****************************************************************
* USERS AFFECTED:  All users of IBM WebSphere Application      *
*                  Server V8.0, V8.5 and V9.0 using connection *
*                  factories that support reathentication      *
****************************************************************
* PROBLEM DESCRIPTION: Connection pool hits it's max           *
*                      connections before attempting to reuse  *
*                      re-authenticateable connections.        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Connection pool reaches max connections for
re-authenticateable connection factories even when not under
load.

Problem conclusion

The connection pool with re-authenticateable connection
factories will maintain fewer connections in the connection
pool when not under a load.

APAR PI61989 is currently targeted for inclusion in
Fix Packs 8.0.0.13, 8.5.5.10, and 9.0.0.1 of WebSphere
Application Server.

In addition, sysroute APAR PI67532 will delivered the fix in
WebSphere Application Server Fix Pack 7.0.0.43.

Please refer to the Recommended Updates page for delivery
information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

In addition, please refer to URL:
http://www.ibm.com/support/docview.wss?rs=404&uid=swg27006970
for Fix Pack PTF information.

Temporary fix

Comments

APAR Information

APAR number
PI61989
Reported component name
WEBSPHERE FOR Z
Reported component ID
5655I3500
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-05-05
Closed date
2016-08-12
Last modified date
2016-08-12

APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:

PI67532

Fix information

Fixed component name
WEBSPHERE FOR Z
Fixed component ID
5655I3500

Applicable component levels

R850 PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS7K4U","label":"WebSphere Application Server for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"850","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
03 May 2022

Tips

PI61989: OPTIMIZE CONNECTION POOL BEHAVIOR WHEN THE FREE POOL DISTRIBUTION TABLE SIZE IS SET TO ONE

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R850 PSY

Document Information

Share your feedback

Need support?