CLI0129E No more handles
CLI0129E No more handles 不再有句柄。
- 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。