data studio disconnects after inactivity

nigelrivett · #1 (**permalink**) 03-09-10, 11:38

We are using Data Studio v2.2 on windows to connect to DB2 v9.5 on Linux .
After a while without use this disconnects and drops any temporary tables.
I's causing some users a lot of dificulty.

Is there any way of preventing or extending this disconnect?
Is it controlled from the client?

ARWinner · #2 (**permalink**) 03-09-10, 11:53

My guess is that your connection is being dropped without your knowledge. This can be controlled from the server. What is the output of: "cat /proc/sys/net/ipv4/tcp_keepalive_time"?

Andy

nigelrivett · #3 (**permalink**) 03-09-10, 12:14

Quote:

Originally Posted by ARWinner

My guess is that your connection is being dropped without your knowledge. This can be controlled from the server. What is the output of: "cat /proc/sys/net/ipv4/tcp_keepalive_time"?

Andy

Thanks
Would that be on the DB2 server which I don't have access to - onlt via a database connection.