database DB2 SQLCODE=-805，SQLSTATE=51002，SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21526209/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
DB2 SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031
提问by Manu
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.
在某个时间点后执行应用程序。在网上没有得到任何富有成效的答案。
回答by Burhan Khalid
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 APPLHEAPSZand MAXAPPLSbut really you should investigate this from the application side.
如果您有权访问该应用程序，请考虑确保在不需要时释放连接。否则，您需要减少对应用程序的限制。尝试增加APPLHEAPSZ，MAXAPPLS但实际上您应该从应用程序方面进行调查。
回答by Jenson
I got this error when I was using prepareStatement in loop without closing it inside loop. Closing the preparedStatement within loop resolved the issue.
当我在循环中使用 prepareStatement 而不在循环内关闭它时出现此错误。在循环内关闭 PreparedStatement 解决了该问题。
回答by csciandr
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.
嗨，我遇到了同样的问题，我可以确认问题是使用相同的 PreparedStatement 进行的操作列表，该列表从未关闭。
关闭后，错误不再发生。
