IBM Support

CLI0129E "No more handles."



My application is running normally then receives error CLI0129E "No more handles".


A call was made to SQLAllocEnv, SQLAllocConnect, or SQLAllocStmt but no more handles are available in the driver.

Resolving The Problem

The resolution is to increase the number of available statement handles.

  1. Ensure your application calls SQLFreeEnv, SQLFreeConnect, or SQLFreeStmt to free up any handles which are no longer being used in the application.

  2. Use the How to increase the number of statement handles technote to increase the number of available statement handles.

[{"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"OTHER - Uncategorised","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018