I connect using squirrel sql 2.0 rc1 to DB2 server,
hosted on AIX-UNIX machine,
I open session & execute 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".
Protocol specific error code(s): "*", "*", "0".
I thought a timeout is set by DB2 admin or something,
but I connect using IBM DB2 command line processor
and no such problem occurs.
I tried also setting the following in Squirrel "File" menu -
> "Global preferences" -> "SQL" tab -> Login timeout
(secs) and set this to zero & sometimes with 20 mins
but the same problem persists. I think it is another
setting as this only for login.
if more details needed, plz contact me