About DB2 error “CLI0106E Connection is closed. SQLSTATE=08003”

by

Posted on by

Sometimes, you meet this error “”CLI0106E Connection is closed. SQLSTATE=08003” when you run DB2 tools.

This error would be due to “The connection specified by the connection handle is no longer active.”

You can add the following to your db2cli.ini file and restart the tool:

QUERYTIMEOUTINTERVAL = 0

If you still meet this error, maybe your network connection is bad, you’d better check your network.

Some DB2 tools you can try: https://www.withdata.com/db2/

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.