IBM Support

CLI0129E "No more handles."

Troubleshooting


Problem

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

Cause


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

UID

swg21394836