Direct link to fix
APAR status
Closed as program error.
Error description
When running the Healthcheck Tool it is possible to run into the error: ORA-01000 maximum open cursors exceeded.
Local fix
STRRTC - 469656 JPM
Problem summary
Problem Description: Some of the HealthCheck Tool database queries leave open cursors that affect performance and memory over time, eventually leading to a maximum open cursors exceeded error (ORA-0100). Platforms Affected: Oracle database Users Affected: Users of HealthCheck Tool V1.0.2.1 and earlier
Problem conclusion
Resolution Summary: A code fix has been provided. Delivered In: 5020500_7 (HealthCheck Tool V1.0.2.2)
Temporary fix
Comments
APAR Information
APAR number
IT09668
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
524
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-06-24
Closed date
2015-07-23
Last modified date
2015-07-29
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
28 August 2023