APAR status
Closed as program error.
Error description
When running external purge, there are errors in the extpurge.log that look like this: ERROR SQLException:::A SQL exception occurred committing batch: SQLException:::java.sql.BatchUpdateException: ORA-00060: deadlock detected while waiting for resource
Local fix
Remove ADMIN_AUDIT from external purge and run deletes manually.
Problem summary
Users Affected: Oracle users who also use external purge. Problem Description: Deadlock errors appear in external purge logs when running under heavy load on Oracle. ERROR SQLException:::A SQL exception occurred committing batch: SQLException:::java.sql.BatchUpdateException: ORA-00060: deadlock detected while waiting for resource Platforms Affected: All
Problem conclusion
Resolution Summary: Code fix provided: Better handled multithreaded deletes on purge tables. Delivered In: 5020500_2
Temporary fix
Comments
APAR Information
APAR number
IT06552
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
524
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-01-16
Closed date
2015-02-25
Last modified date
2015-02-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
STR B2B INTEGRA
Fixed component ID
5725D0600
Applicable component levels
R525 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
25 February 2015