IBM Support

IC77662: TRUSTED STORED PROCEDURES WITHIN THE CONNECTION CONTEXT NOT FULLY RELEASED MEMORY DURING SUBSEQUENT DISCONNECT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When using trusted stored procedures, some of the memory is not
    freed  even though the context  of the query is completed.
    So you may find private memory usage increases on the db2sysc
    process.
    The current problem is, the memory is fully released only when
    the library  is unloaded. This APAR will fix the problem.
    
    
    On busy systems, the application library may not be unloaded
    often, therefore cause a memory leak effectively.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When using trusted stored procedures, some of the memory is  *
    * not                                                          *
    * freed  even though the context  of the query is completed.   *
    *                                                              *
    * So you may find private memory usage increases on the        *
    * db2sysc                                                      *
    * process.                                                     *
    *                                                              *
    * The current problem is, the memory is fully released only    *
    * when                                                         *
    * the library  is unloaded. This APAR will fix the problem.    *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * On busy systems, the application library may not be unloaded *
    *                                                              *
    * often, therefore cause a memory leak effectively.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version V9.7Fixpack 5                         *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC77662

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-22

  • Closed date

    2011-12-07

  • Last modified date

    2011-12-07

  • 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

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 December 2011