IBM Support

IT34088: INCREASED SESSION MEMORY USAGE DUE TO STATEMENTS INSIDE STORED PROCEDURES NOT BEING FREED

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

  • t appears that statement descriptor blocks for statements inside
    stored procedures may not be getting freed correctly.  This can
    be seen via large amounts of statements in the onstat -g stm
    output for a session, along with increased memory usage for the
    session.
    
    onstat -g stm:
    
    IBM Informix Dynamic Server Version 12.10.FC12W1XQ -- On-Line --
    Up 00:00:49 -- 549724 Kbytes
    
    session 9
    ---------------------------------------------------------------
    sdblock          heapsz     flags statement ('*' = Open cursor)
    461bf028         7712       ----- *execute procedure p1()
    461bf2e0         7712       ----- *execute procedure p1()
    461bf598         13024      -----  <SPL(db1:532), stmt(1):SELECT
    >
    461bf850         12968      -----  <SPL(db1:532), stmt(3):SELECT
    >
    461bfb08         12968      -----  <SPL(db1:532), stmt(5):SELECT
    >
    461bfdc0         13000      -----  <SPL(db1:532), stmt(7):SELECT
    >
    461c0078         12992      -----  <SPL(db1:532), stmt(9):SELECT
    >
    461c0330         12968      -----  <SPL(db1:532),
    stmt(11):SELECT >
    461c05e8         12992      -----  <SPL(db1:532),
    stmt(13):SELECT >
    461c08a0         12968      -----  <SPL(db1:532),
    stmt(15):SELECT >
    461c0b58         12968      -----  <SPL(db1:532),
    stmt(17):SELECT >
    461c0e10         12968      -----  <SPL(db1:532),
    stmt(19):SELECT >
    461c10c8         12968      -----  <SPL(db1:532),
    stmt(21):SELECT >
    461c1380         12968      -----  <SPL(db1:532),
    stmt(23):SELECT >
    461c1638         12968      -----  <SPL(db1:532),
    stmt(25):SELECT >
    461c18f0         12968      -----  <SPL(db1:532),
    stmt(27):SELECT >
    4643f028         12992      -----  <SPL(db1:532),
    stmt(29):SELECT >
    4643f2e0         12992      -----  <SPL(db1:532), stmt(1):SELECT
    >
    4643f598         12992      -----  <SPL(db1:532), stmt(3):SELECT
    >
    4643f850         12968      -----  <SPL(db1:532), stmt(5):SELECT
    >
    4643fb08         12968      -----  <SPL(db1:532), stmt(7):SELECT
    >
    4643fdc0         12968      -----  <SPL(db1:532), stmt(9):SELECT
    >
    46440078         12968      -----  <SPL(db1:532),
    stmt(11):SELECT >
    46440330         12968      -----  <SPL(db1:532),
    stmt(13):SELECT >
    464405e8         12968      -----  <SPL(db1:532),
    stmt(15):SELECT >
    464408a0         12968      -----  <SPL(db1:532),
    stmt(17):SELECT >
    46440b58         12968      -----  <SPL(db1:532),
    stmt(19):SELECT >
    46440e10         12992      -----  <SPL(db1:532),
    stmt(21):SELECT >
    464410c8         12968      -----  <SPL(db1:532),
    stmt(23):SELECT >
    46441380         12968      -----  <SPL(db1:532),
    stmt(25):SELECT >
    46441638         12968      -----  <SPL(db1:532),
    stmt(27):SELECT >
    464418f0         12968      -----  <SPL(db1:532),
    stmt(29):SELECT >
    465f5028         13016      -----  <SPL(db1:532), stmt(1):SELECT
    >
    465f52e0         12968      -----  <SPL(db1:532), stmt(3):SELECT
    >
    465f5598         12968      -----  <SPL(db1:532), stmt(5):SELECT
    >
    ...
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * It appears that statement descriptor blocks for statements   *
    * inside                                                       *
    * stored procedures may not be getting freed correctly.  This  *
    * can                                                          *
    * be seen via large amounts of statements in the onstat -g stm *
    * output for a session, along with increased memory usage for  *
    * the                                                          *
    * session.                                                     *
    *                                                              *
    * onstat -g stm:                                               *
    *                                                              *
    * IBM Informix Dynamic Server Version 12.10.FC12W1XQ --        *
    * On-Line --                                                   *
    * Up 00:00:49 -- 549724 Kbytes                                 *
    *                                                              *
    * session 9                                                    *
    * ------------------------------------------------------------ *
    * ---                                                          *
    * sdblock          heapsz     flags statement ('*' = Open      *
    * cursor)                                                      *
    * 461bf028         7712       ----- *execute procedure p1()    *
    * 461bf2e0         7712       ----- *execute procedure p1()    *
    * 461bf598         13024      -----  <SPL(db1:532),            *
    * stmt(1):SELECT                                               *
    * >                                                            *
    * 461bf850         12968      -----  <SPL(db1:532),            *
    * stmt(3):SELECT                                               *
    * >                                                            *
    * 461bfb08         12968      -----  <SPL(db1:532),            *
    * stmt(5):SELECT                                               *
    * >                                                            *
    * 461bfdc0         13000      -----  <SPL(db1:532),            *
    * stmt(7):SELECT                                               *
    * >                                                            *
    * 461c0078         12992      -----  <SPL(db1:532),            *
    * stmt(9):SELECT                                               *
    * >                                                            *
    * 461c0330         12968      -----  <SPL(db1:532),            *
    * stmt(11):SELECT >                                            *
    * 461c05e8         12992      -----  <SPL(db1:532),            *
    * stmt(13):SELECT >                                            *
    * 461c08a0         12968      -----  <SPL(db1:532),            *
    * stmt(15):SELECT >                                            *
    * 461c0b58         12968      -----  <SPL(db1:532),            *
    * stmt(17):SELECT >                                            *
    * 461c0e10         12968      -----  <SPL(db1:532),            *
    * stmt(19):SELECT >                                            *
    * 461c10c8         12968      -----  <SPL(db1:532),            *
    * stmt(21):SELECT >                                            *
    * 461c1380         12968      -----  <SPL(db1:532),            *
    * stmt(23):SELECT >                                            *
    * 461c1638         12968      -----  <SPL(db1:532),            *
    * stmt(25):SELECT >                                            *
    * 461c18f0         12968      -----  <SPL(db1:532),            *
    * stmt(27):SELECT >                                            *
    * 4643f028         12992      -----  <SPL(db1:532),            *
    * stmt(29):SELECT >                                            *
    * 4643f2e0         12992      -----  <SPL(db1:532),            *
    * stmt(1):SELECT                                               *
    * >                                                            *
    * 4643f598         12992      -----  <SPL(db1:532),            *
    * stmt(3):SELECT                                               *
    * >                                                            *
    * 4643f850         12968      -----  <SPL(db1:532),            *
    * stmt(5):SELECT                                               *
    * >                                                            *
    * 4643fb08         12968      -----  <SPL(db1:532),            *
    * stmt(7):SELECT                                               *
    * >                                                            *
    * 4643fdc0         12968      -----  <SPL(db1:532),            *
    * stmt(9):SELECT                                               *
    * >                                                            *
    * 46440078         12968      -----  <SPL(db1:532),            *
    * stmt(11):SELECT >                                            *
    * 46440330         12968      -----  <SPL(db1:532),            *
    * stmt(13):SELECT >                                            *
    * 464405e8         12968      -----  <SPL(db1:532),            *
    * stmt(15):SELECT >                                            *
    * 464408a0         12968      -----  <SPL(db1:532),            *
    * stmt(17):SELECT >                                            *
    * 46440b58         12968      -----  <SPL(db1:532),            *
    * stmt(19):SELECT >                                            *
    * 46440e10         12992      -----  <SPL(db1:532),            *
    * stmt(21):SELECT >                                            *
    * 464410c8         12968      -----  <SPL(db1:532),            *
    * stmt(23):SELECT >                                            *
    * 46441380         12968      -----  <SPL(db1:532),            *
    * stmt(25):SELECT >                                            *
    * 46441638         12968      -----  <SPL(db1:532),            *
    * stmt(27):SELECT >                                            *
    * 464418f0         12968      -----  <SPL(db1:532),            *
    * stmt(29):SELECT >                                            *
    * 465f5028         13016      -----  <SPL(db1:532),            *
    * stmt(1):SELECT                                               *
    * >                                                            *
    * 465f52e0         12968      -----  <SPL(db1:532),            *
    * stmt(3):SELECT                                               *
    * >                                                            *
    * 465f5598         12968      -----  <SPL(db1:532),            *
    * stmt(5):SELECT                                               *
    * >                                                            *
    * ...                                                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 12.10.xC15 (when available) or    *
    * 14.10.xC5.                                                   *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT34088

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-09-02

  • Closed date

    2021-01-28

  • Last modified date

    2021-01-28

  • 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

[{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
29 January 2021