IC77876: MEMORY LEAK OBSERVED WITH DYNAMIC ROUTINE-NAME SPECIFICATION

APAR status

• Closed as program error.

Error description

• Dynamic routine-name specification simplified the writing of an
  SPL routine that calls another routine who's name is not known
  until runtime. A variable can be used to dynamically build the
  name of a procedure to execute, and when this variable is used
  in the 'execute procedure' statement, memory is allocated to the
  session. Once the procedure has been executed, this memory is
  never released until the session terminates. Due to the
  allocation of memory, performance may also impacted.
  
  If there are sufficient calls to these SPL variables, the
  session memory will become exhausted and fail with the error
  -208.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When using SPL variables to allow dynamic execution of       *
  * stored procedures, memory allocation grows until the session *
  * terminates. Due to the allocation of memory, performance is  *
  * impacted.                                                    *
  *                                                              *
  * 80,000 function calls will force the allocation of 3 GB's of *
  * memory from the 'ralloc' pool.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC10 or use fixpack.                        *
  ****************************************************************
  

Problem conclusion

• Memory leak will not be seen. Fixed in 11.50.xC10.
  

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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RB50 PSN

     UP