CLI0129E尝试分配句柄失败错误
数据库是：db2 v9
应用程序：.net
程序报错：CLI0129E 尝试分配句柄失败，因为不再有句柄可供分配数据库的db2diag.log中无任何错误信息。请问是什么原因引起的哪？
应用程序：.net
程序报错：CLI0129E 尝试分配句柄失败，因为不再有句柄可供分配数据库的db2diag.log中无任何错误信息。请问是什么原因引起的哪？
6同行回答
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.收起
cd
db2 connect to
db2 "BIND @db2cli.lst BLOCKING ALL CLIPKG 6 grant public"
db2 terminate
cd
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.收起
这个我搜索到了，可是我不知道这个到底是为什么错误，由于生产环境不能随便修改东西！收起
浏览1028
CLI0129E An attempt to allocate a handle failed because there are no
more handles to allocate.
Explanation:
A CLI handle is a variable that refers to a data object allocated and
managed by DB2 CLI. There are four types of handles in CLI:
* Environment handle
* Connection handle
* Statement handle
* Descriptor handle
This message is returned when all handles that can be allocated have
been allocated, and an attempt is made to allocate a handle using one of
the following functions:
* SQLAllocEnv
* SQLAllocConnect
* SQLAllocStmt
* SQLAllocHandle
* SQLExecute
* SQLExecDirect
User response:
Free handles that are no longer being used in the application by calling
SQLFreeEnv, SQLFreeConnect, or SQLFreeStmt, or SQLFreeHandle.
To reduce the incidence of this error take one or both of the following
actions:
* Modify the application to release handles more frequently.
* Increase the number of statement handles that can be allocated by
increasing the CLIPkg CLI/ODBC configuration parameter using the BIND
command.
Related information
Handles in CLI
SQLFreeHandle function (CLI) - Free handle resources
BIND command
CLIPkg CLI/ODBC configuration keyword收起
more handles to allocate.
Explanation:
A CLI handle is a variable that refers to a data object allocated and
managed by DB2 CLI. There are four types of handles in CLI:
* Environment handle
* Connection handle
* Statement handle
* Descriptor handle
This message is returned when all handles that can be allocated have
been allocated, and an attempt is made to allocate a handle using one of
the following functions:
* SQLAllocEnv
* SQLAllocConnect
* SQLAllocStmt
* SQLAllocHandle
* SQLExecute
* SQLExecDirect
User response:
Free handles that are no longer being used in the application by calling
SQLFreeEnv, SQLFreeConnect, or SQLFreeStmt, or SQLFreeHandle.
To reduce the incidence of this error take one or both of the following
actions:
* Modify the application to release handles more frequently.
* Increase the number of statement handles that can be allocated by
increasing the CLIPkg CLI/ODBC configuration parameter using the BIND
command.
Related information
Handles in CLI
SQLFreeHandle function (CLI) - Free handle resources
BIND command
CLIPkg CLI/ODBC configuration keyword收起
浏览1307