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

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 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

• R850 PSY

     UP

• R900 PSY

     UP