IC82227: IN A NON-LOGGING DATABASE A MEMORY LEAK MIGHT BE OBSERVED IN A SESSION POOL, MEMID SQL

APAR status

• Closed as program error.

Error description

• This problem was identified in a case where a session executed a
  procedure which was selecting from another procedure.
  
  Symptom is an increasing memory usage for this session
   (check 'onstat -g ses <sid>' total memory column),
  which is not freed when repeatedly executing the same SQL.
  An 'onstat -g ufr <sid> will reveal that most of this memory is
  used for memid 'sql'.
  
  This problem has only been observed on databases without
  logging.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Prepared query executed repeatedly and the query uses        *
  * aggregate push down can leak memory in session pool.         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The query uses excess memory in session pool                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC5                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC5
  

Temporary fix

Comments

• For download information, go to:
  http://www.ibm.com/support/fixcentral
  

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

• RB70 PSY

     UP