IBM Support

IT15404: MEMORY LEAK IN SQOPUTIL.C:GET_DIST()

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.

 

APAR status

  • Closed as program error.

Error description

  • SQL with an INNER JOIN and UNION run repeatedly in same session
    leaks memory in 4k blocks:
    
    
    4fd7e978 736        sql          4062   sqoputil.c:7613
    4fd7ec58 736        sql          4062   sqoputil.c:7613
    50617c00 736        sql          4062   sqoputil.c:7613
    5104b448 736        sql          4062   sqoputil.c:7613
    5104b800 736        sql          4062   sqoputil.c:7613
    5104bae0 736        sql          4062   sqoputil.c:7613
    4f82d000 736        sql          4062   sqoputil.c:7613
    4f82d448 736        sql          4062   sqoputil.c:7613
    4f82d800 736        sql          4062   sqoputil.c:7613
    4f82dae0 736        sql          4062   sqoputil.c:7613
    4c2dc000 736        sql          4062   sqoputil.c:7613
    4c2dc448 736        sql          4062   sqoputil.c:7613
    4c2dc800 736        sql          4062   sqoputil.c:7613
    4c2dcae0 736        sql          4062   sqoputil.c:7613
    51679000 736        sql          4062   sqoputil.c:7613
    51679448 736        sql          4062   sqoputil.c:7613
    51679800 736        sql          4062   sqoputil.c:7613
    51679ae0 736        sql          4062   sqoputil.c:7613
    50e19000 736        sql          4062   sqoputil.c:7613
    50e19448 736        sql          4062   sqoputil.c:7613
    50e19800 736        sql          4062   sqoputil.c:7613
    50e19ae0 736        sql          4062   sqoputil.c:7613
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IBM Informix Server 11.70.xC9                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IBM Informix Server 11.70.xC9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT15404

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-05-23

  • Closed date

    2017-06-09

  • Last modified date

    2017-06-09

  • 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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

  • RA10 PSN

       UP

  • RA10 PSY

       UP

  • RB10 PSN

       UP

  • RB10 PSY

       UP

  • RB50 PSN

       UP

  • RB50 PSY

       UP

  • RB70 PSN

       UP

  • RB70 PSY

       UP

  • RC10 PSN

       UP

  • RC10 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
09 June 2017