IBM Support

IT05306: PERFORMANCE OF A STORED PROCEDURE PROGRESSIVELY DECREASES WHEN RUN MANY TIMES, CAUSING A MEMORY LEAK IN RALLOC SESSION MEMORY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • You might observe that a stored procedure, called many times
    with different variables, progressively gets slower with each
    call.
    Apart from the decreased performance, you might also observe an
    increase in the session memory's ralloc pool.
    
    After an 'update statistics for procedure', the procedure is
    fast but will once again start to progressively get slower.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * fixed in 12.10.xC6                                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Problem is fixed in 12.10.xC6 and confirmed by submitter.    *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT05306

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-31

  • Closed date

    2015-12-30

  • Last modified date

    2015-12-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

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":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 December 2015