IT05306: PERFORMANCE OF A STORED PROCEDURE PROGRESSIVELY DECREASES WHEN RUN MANY TIMES, CAUSING A MEMORY LEAK IN RALLOC SESSION MEMORY

APAR status

• Closed as fixed if next.

Error description

• You might observe that a stored procedure, called many times
  with different variables, progressively gets slower with each
  call.
  Apart from the decreased performance, you might also observe an
  increase in the session memory's ralloc pool.
  
  After an 'update statistics for procedure', the procedure is
  fast but will once again start to progressively get slower.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * fixed in 12.10.xC6                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Problem is fixed in 12.10.xC6 and confirmed by submitter.    *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• RA10 PSN

     UP

• RA10 PSY

     UP

• RB10 PSN

     UP

• RB10 PSY

     UP

• RB50 PSN

     UP

• RB50 PSY

     UP

• RB70 PSN

     UP

• RB70 PSY

     UP

• RC10 PSN

     UP

• RC10 PSY

     UP