关闭

CLI0129E No more handles

标签: databaseperformanceresourcesapplicationibmsystem
1007人阅读 评论(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。

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:10378次
    • 积分:176
    • 等级:
    • 排名:千里之外
    • 原创:6篇
    • 转载:1篇
    • 译文:0篇
    • 评论:1条
    文章分类
    文章存档
    最新评论