JR32638: ABANDONED TRANSACTION CLEANUP AND IMPROVED SESSION CLEANUP

APAR status

• Closed as program error.

Error description

• In 8.0.1, we saw that there were out of memory errors making
  clients unable to log in to Information Server.  Part of this
  problem came from from the large number of threads that are
  spawned to clean up sessions.  Sessions could not be cleaned
  up, since new threads could not be created. The error seen in
  the WAS log is "java.lang.OutOfMemoryError: unable to create
  new native thread".  The session cleanup changes address this.
  
  In addition, there have been customers who have experienced
  deadlock issues due to abandoned transactions holding locks on
  the database.
  

Local fix

• Now, instead of having a new thread spawned for each session
  to clean up, we have two long-running threads to perform the
  cleanup.  The first thread kills abandoned transactions
  associated with the session, and the second thread clears the
  session cache and unlocks any objects that are associated with
  the session.
  
  The fix also includes cleanup of abandoned sessions.  Now, when
  a session is terminated (whether abnormally or not), we check
  to see if there are any pending transactions associated with it.
   If there are, we abort them.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of DS
  ****************************************************************
  PROBLEM DESCRIPTION:
  Issues with cleanup of abandoned transactions
  ****************************************************************
  RECOMMENDATION:
  Apply the patch
  ****************************************************************
  

Problem conclusion

• Applied a fix
  

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:

Modules/Macros

• XMETA
  

Fix information

• Fixed component name

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R810 PSN

     UP