Fixes are available
9.0.0.6: WebSphere Application Server traditional V9.0 Fix Pack 6
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
9.0.0.7: WebSphere Application Server traditional V9.0 Fix Pack 7
9.0.0.8: WebSphere Application Server traditional V9.0 Fix Pack 8
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
9.0.0.9: WebSphere Application Server traditional V9.0 Fix Pack 9
9.0.0.10: WebSphere Application Server traditional V9.0 Fix Pack 10
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
9.0.0.11: WebSphere Application Server traditional V9.0 Fix Pack 11
9.0.5.0: WebSphere Application Server traditional Version 9.0.5 Refresh Pack
9.0.5.1: WebSphere Application Server traditional Version 9.0.5 Fix Pack 1
9.0.5.2: WebSphere Application Server traditional Version 9.0.5 Fix Pack 2
8.5.5.17: WebSphere Application Server V8.5.5 Fix Pack 17
9.0.5.3: WebSphere Application Server traditional Version 9.0.5 Fix Pack 3
9.0.5.4: WebSphere Application Server traditional Version 9.0.5 Fix Pack 4
9.0.5.5: WebSphere Application Server traditional Version 9.0.5 Fix Pack 5
WebSphere Application Server traditional 9.0.5.6
9.0.5.7: WebSphere Application Server traditional Version 9.0.5 Fix Pack 7
9.0.5.8: WebSphere Application Server traditional Version 9.0.5.8
8.5.5.20: WebSphere Application Server V8.5.5.20
8.5.5.18: WebSphere Application Server V8.5.5 Fix Pack 18
8.5.5.19: WebSphere Application Server V8.5.5 Fix Pack 19
9.0.5.9: WebSphere Application Server traditional Version 9.0.5.9
9.0.5.10: WebSphere Application Server traditional Version 9.0.5.10
8.5.5.16: WebSphere Application Server V8.5.5 Fix Pack 16
8.5.5.21: WebSphere Application Server V8.5.5.21
9.0.5.11: WebSphere Application Server traditional Version 9.0.5.11
APAR status
Closed as program error.
Error description
When a connection is pulled from the pool and the autoCommit value is changed programmatically, the default value is not reset on the connection for the next consumer until after connection validation has occurred. This can cause some odd statistics to occur for DB access such as a high number of rollbacks/aborts during connection validation. The rollbacks are harmless, but it can be alarming for customers who are monitoring for such occurrences.
Local fix
Moving to a JDBC 4.0 compliant driver or turning off connection validation will stop the rollbacks.
Problem summary
**************************************************************** * USERS AFFECTED: All users of connection validation in IBM * * WebSphere Application Server V8.5 and V9 * **************************************************************** * PROBLEM DESCRIPTION: Harmless rollbacks occur during * * connection validation when the * * autoCommit * * value has been changed to false * * programmatically. * **************************************************************** * RECOMMENDATION: * **************************************************************** When a connection is pulled from the pool and the autoCommit value has been changed programmatically, the default value is not reset on the connection for the next consumer until after connection validation has occurred. This can cause some odd statistics to occur for DB access such as a high number of rollbacks/aborts during connection validation since the connections are rolled back if autoCommit is false. The rollbacks are harmless, but it can be alarming for customers who are monitoring for such occurrences.
Problem conclusion
The code was updated so that the autoCommit value is reset to th default value before connection validation occurs. The fix for this APAR is currently targeted for inclusion in fix pack 8.5.5.13 and 9.0.0.6. Please refer to the Recommended Updates page for delivery information: http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
Temporary fix
Comments
APAR Information
APAR number
PI87631
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
2017-09-20
Closed date
2017-10-25
Last modified date
2017-10-25
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
WEBSPHERE FOR Z
Fixed component ID
5655I3500
Applicable component levels
R850 PSY
UP
Document Information
Modified date:
04 May 2022