IC87560: ASSIGNMENT INTO ESQL ROW VARIABLE DOES NOT DELETE CHILDREN

APAR status

• Closed as program error.

Error description

• A memory growth is observed when a flow continually assigns a
  new value or message tree into an existing field of an ESQL
  ROW variable. The existing children of the field are detached
  and the new values are copied in to place.
  As the existing children are detached and not deleted then they
  are not returned to the syntax element pool for reuse.
  
  For local scoped ROW variables when the ROW variable goes
  out of scope then the detached syntax elements, along with the
  currently in use ones are all freed up for reuse.
  
  With SHARED ROW variables the variables only go out of scope
  when the flow is undeployed and so the detached syntax
  elements are not freed for reuse until this time.
  
  In both instances this can appear as a memory leak.
  
  If NULL is assigned in to the existing field of an ESQL ROW
  variable then the existing children are deleted and not
  detached.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of WebSphere Message Broker who use ESQL ROW
  variables.
  
  
  Platforms affected:
  MultiPlatform, z/OS
  
  ****************************************************************
  PROBLEM SUMMARY:
  A memory growth is observed when a flow continually assigns a
  new value or message tree into an existing field of an ESQL
  ROW variable. The existing children of the field are detached
  and the new values are copied in to place.
  As the existing children are detached and not deleted then they
  are not returned to the syntax element pool for reuse.
  

Problem conclusion

• WebSphere Message Broker has been modified to delete the
  existing children of ESQL ROW variables when a new value or
  message tree is assigned.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Platform           v8.0
  --------           --------------------
  Multiplatforms     8.0.0.3
  
  Platform           v7.0
  --------           --------------------
  Multiplatforms     7.0.0.6
  
  The latest available maintenance can be obtained from
  'WebSphere Message Broker Recommended Fixes'
  http://www.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available, information on
  its planned availability can be found in 'WebSphere Message
  Broker Planned Maintenance Release Dates'
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

  WEB MESSAGE BRO

• Fixed component ID

  5724J0510

Applicable component levels

• R700 PSY

     UP