IBM Support

IT09668: CURSOR LEAK IN HEALTHCHECK TOOL

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.

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

  • 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

  • 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":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
29 July 2015