IC70752: MEMORY LEAK WHEN STORED PROCEDURE IS CREATED, DROPPED AND EXECUTED IN A LOOP

APAR status

• Closed as program error.

Error description

• If a stored procedure is dropped and recreated while it is being
  executed
  by a different session, a stale entry can remain in the stored
  procedure
  cache. If this happens often and for a long time a huge memory
  leak can
  be produced in the procpool.
  
  onstat -g mem:
  
    Pool Summary:
    name      class addr      totalsize  freesize  #allocfrag
  #freefrag
    procpool  V    33c17f040 7840239616 252531824 6298788
  560734
  
  onstat -g prc:
  
    UDR Cache:
        Number of lists            : 31
        PC_POOLSIZE                : 127
  
  
    UDR Cache Entries:
  
    list#  id  ref_cnt  dropped?  heap_ptr        udr name
    --------------------------------------------------------------
    0      5064    1      1      10cf96838      d@shmprot:.p1
    0      5051    2      1      10e774838      d@shmprot:.p1
    0      5018    2      1      10e73ec38      d@shmprot:.p1
    0      4973    1      1      10e71f038      d@shmprot:.p1
    0      4964    3      1      10e717038      d@shmprot:.p1
    ...
    1      5046    2      1      10e770838      d@shmprot:.p1
    1      5001    3      1      10e73a838      d@shmprot:.p1
    1      4968    3      1      10e719438      d@shmprot:.p1
    1      4946    3      1      10e702438      d@shmprot:.p1
    ...
    ...
    30      5036    2      1      10e767838      d@shmprot:.p1
    30      5023    2      1      10e756038      d@shmprot:.p1
    30      4990    3      1      10e734038      d@shmprot:.p1
    ...
  
        Total number of udr entries: 37263
        Number of entries in use   : 37089
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * User running create and drop procedure in a loop or using    *
  * multiple sessions                                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When user runs create and drop procedure in a loop, server   *
  * can leak memory and SPL entry still shows in the server      *
  * cache.                                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC8.                                        *
  ****************************************************************
  

Problem conclusion

• Fixed in 11.50.xC8.
  

Temporary fix

Comments

APAR Information

• 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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP