DB2 SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031

Question

I am getting this error below :

 com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031, DRIVER=3.58.81 

in the execution of application after a certain point of time. Not got any fruitful answer on the web.

Answer 1

Hi I came into the same problem and I can confirm that the problem was a list of operations made with the same PreparedStatement, which was never closed.
After closing it the error did not occur anymore.

Answer 2

I got this error when I was using prepareStatement in loop without closing it inside loop. Closing the preparedStatement within loop resolved the issue.

Answer 3

This is an indication that the application is running out of resources; possibly due to not closing connections (too many prepared statements or other such poor programming).

If you have access to the application, consider making sure the connections are released when not needed. Otherwise, you need to reduce the constraints on the application. Try increasing APPLHEAPSZ and MAXAPPLS but really you should investigate this from the application side.