IBM Support

PH22988: Poor performance when transaction and compensation recovery logs are stored in a relational database.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When transaction or compensation recovery logs are stored in
    a relational database, a heavy 2PC transaction or compensation
    workload results in poor performance die to excessive database
    contention in the recovery log component.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  WebSphere Application Server users that     *
    *                  have configured the transaction or          *
    *                  compensation service to store its logs in a *
    *                  database                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: If recovery logs are stored in a        *
    *                      relational database a heavy 2PC or      *
    *                      compensation workload can lead to poor  *
    *                      performance.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When the recovery logs are stored in a relational database,
    the recovery logging component suffers from excessive
    contention as multiple threads attempt to make database
    updates. The work performed against the database is not batched
    up efficiently and logging becomes a performance bottleneck.
    

Problem conclusion

  • The relational database version of the recovery logging componen
    was modified to batch work more efficiently when the system is
    under load.
    
    The fix for this APAR is targeted for inclusion in fix packs
    8.5.5.19 and 9.0.5.6. For more information, see 'Recommended
    Updates for WebSphere Application Server':
    https://www.ibm.com/support/pages/node/715553
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH22988

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-03-05

  • Closed date

    2020-11-27

  • Last modified date

    2020-11-27

  • 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

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

[{"Line of Business":{"code":"LOB36","label":"IBM Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"850"}]

Document Information

Modified date:
28 November 2020