PI87631: HIGH NUMBER OF ROLLBACK/ABORTS OCCURRING DURING CONNECTION VALIDATION FOR JDBC CONNECTION POOLS.

Fixes are available

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

[{"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:
04 May 2022

Tips

PI87631: HIGH NUMBER OF ROLLBACK/ABORTS OCCURRING DURING CONNECTION VALIDATION FOR JDBC CONNECTION POOLS.

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?