IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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":"BU048","label":"IBM Software"},"Product":{"code":"SSCWL8S","label":"General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"850","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
25 October 2017