8

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.

Dhanish Jose
  • 739
  • 1
  • 8
  • 19
Manu
  • 453
  • 2
  • 6
  • 15
  • Which version of DB2? What reason codes/other information are you getting? Did the listed resolution steps not work? `-805`usually indicates a package is missing; I've never heard of it cropping up during runtime, though (it usually prevents statements from being run right off). – Clockwork-Muse Feb 07 '14 at 07:47
  • we are using DB2 9.7 version. We are still not able to figure out the real cause. As this error is not regular. – Manu Feb 07 '14 at 13:43

3 Answers3

7

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

Jenson
  • 635
  • 2
  • 11
  • 20
  • 1
    Were you creating new PreparedStatements inside the loop by any chance ? If that was the case, maybe creating the PreparedStatement just once before the loop would have been a more efficient solution than closing it on each loop cycle. – Etienne Delavennat Jan 31 '18 at 16:10
6

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.

Burhan Khalid
  • 169,990
  • 18
  • 245
  • 284
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.

csciandr
  • 132
  • 1
  • 2
  • 14
  • A PreparedStatement is made to be open once, reused as many times as needed (be it 1 000 000 times) and closed once. Perhaps you weren't commiting the data often enough, but I don't see how reusing the same PreparedStatement object would yield that error ... – Etienne Delavennat Jan 31 '18 at 16:37