Mr. Liang的专栏

一步一脚印

CLI0129E No more handles

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。

阅读更多
个人分类: db2
上一篇SQL0964C The transaction log for the database is full.
下一篇SQL0805N Package "NULLID.SQLLD003" was not found.
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭