[Squirrel-sql-users] Communication error with DB2

[Ashraf F. <ash...@gm...>]

Dears,
I connect using squirrel sql 2.0 rc1 to DB2 server, hosted on UNIX machine,=
=20
I open session & excute statments and everything works fine, untill I leave=
=20
the squirrel without executing any statments for around 4 - 6 mins, then I=
=20
try to execute any valid statment, I got this error:
 Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL30081N A=
=20
communication error has been detected. Communication protocol being used:=
=20
"TCP/IP". Communication API being used: "SOCKETS". Location where the error=
=20
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=
=20
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=
d=20
set this to zero & sometimes with 20 mins but the same problem persists.
 Can anyone help?

--=20
Thanks, best regards,
Ashraf Fouad