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
R850 PSY
UP
R900 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
02 November 2021