I connect using squirrel sql 2.0 rc1 to DB2 server, hosted on UNIX machine,=
I open session & excute statments and everything works fine, untill I leave=
the squirrel without executing any statments for around 4 - 6 mins, then I=
try to execute any valid statment, I got this error:
Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL30081N A=
communication error has been detected. Communication protocol being used:=
"TCP/IP". Communication API being used: "SOCKETS". Location where the error=
was detected: "". Communication function detecting the error: "recv".=20
Protocol specific error code(s): "*", "*", "0". SQLSTATE=3D08001
I thought a timeout is set by DB2 admin or something, but I connect using=
IBM DB2 command line processor and such problem occurs.
I tried also setting the following in Squirrel
"File" menu -> "Global preferences" -> "SQL" tab -> Login timeout (secs) an=
set this to zero & sometimes with 20 mins but the same problem persists.
Can anyone help?
Thanks, best regards,