CLI0129E尝试分配句柄失败错误

数据库是:db2 v9应用程序:.net程序报错:CLI0129E  尝试分配句柄失败,因为不再有句柄可供分配数据库的db2diag.log中无任何错误信息。请问是什么原因引起的哪?显示全部
数据库是:db2 v9
应用程序:.net


程序报错:CLI0129E  尝试分配句柄失败,因为不再有句柄可供分配数据库的db2diag.log中无任何错误信息。请问是什么原因引起的哪?收起
参与13

查看其它 5 个回答weiruan85的回答

weiruan85weiruan85数据库管理员ibm
For example:

    cd /sqllib/bnd
    db2 connect to
    db2 "BIND @db2cli.lst BLOCKING ALL CLIPKG 6 grant public"
    db2 terminate
    cd /sqllib/cfg
    Edit the db2cli.ini file adding the following line under your dbalias section:

    CLIPKG=6

    Note: CLIPKG 6 may not be high enough.

Ensure that you restart the application after rebinding to test.

When changing the CLIPKG value caution should be taken. The higher this value is the more system resources can be used, and performance may take a hit as more open statement handles are in use. It is very possible to hit hardware and operating system limitations when setting this at high values.
政府机关 · 2013-12-03
浏览1325

回答者

weiruan85
数据库管理员ibm

weiruan85 最近回答过的问题

回答状态

  • 发布时间:2013-12-03
  • 关注会员:3 人
  • 回答浏览:1325
  • X社区推广