LO75668: SQLEXCEPTIONS CAN CAUSE UNNECESSARY CONSTRAINED STATE

APAR status

• Closed as program error.

Error description

• SqlExceptions thrown by the database backend while Traveler is
  creating a new transaction can cause the Traveler database
  connection pool to lose accurate count of the number of open
  connections. This can cause a server to go into constrained
  state due to the number of outstanding database connections, but
   the connection count will never come back down, and so the
  server will remain in constrained state until a restart.
  

Local fix

• Restarting the Traveler server can bring it out of constrained
  state if this problem is the cause.
  

Problem summary

• Notes Traveler server may leak database connections causing an
  artificial constrained state due to low DB connection
  availability.
  

Problem conclusion

• The Notes Traveler server has been updated to prevent this
  scenario.
  

Temporary fix

• This fix is included in Notes Traveler 8.5.3 UP2 IF3, 9.0.0.1
  and all later releases.
  
  For the latest Notes Traveler maintenance release information
  see this technote:
  http://www.ibm.com/support/docview.wss?uid=swg24019529
  

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

  LOTUS NOTES TRA

• Fixed component ID

  5724E6204

Applicable component levels

• R853 PSY

     UP