CLI0129E No more handles

最新推荐文章于 2021-04-04 22:40:02 发布

unika_ly12

最新推荐文章于 2021-04-04 22:40:02 发布

阅读量1.3k

点赞数

分类专栏： db2 文章标签： database performance resources application ibm system

本文链接：https://blog.csdn.net/unika_ly12/article/details/1789491

版权

3 篇文章 0 订阅

订阅专栏

CLI0129E No more handles 不再有句柄。

IBM官方提供的解决方案如下：

Increase the database configuration parameter APPLHEAPSZ for the database in question by issuing the UPDATE DB CFG command.
Connect to the database and rebind CLI packages with a higher CLIPKG value. This will allow more handles but the downside is that this can impact performance due to the overhead of keeping more handles open.
Close unused or unneeded handles in the application to free up system resources so they can be used to allocate more handles as needed. Keeping handles open when unnecessary is often the reason for this error.

在我看来发生这个错误的绝大部分是由于上述第三个原因，也就是没有及时的关闭connections, statements 或 resultsets。