How can I get my connection to Vertica to stay alive?

The timeout out period for Vertica and/or the JDBC driver does not get set at the database level.

However, it is advisable to keep the TCP Keep Alive settings at the OS level lower than the timeout parameter at the client level or at firewall to avoid such connection timeouts.

Please check with your network admin for firewall timeout value, or any timeout value set at the client level. Then modify kernel parameter tcp_keepalive_time to a value lower than the firewall timeout values. This should give the TCP keepalive a chance to keep the connection alive.

Here is a forum post that may help as well: http://vertica-forums.com/viewtopic.php?t=252

Thanks,

Pat

Below command may be useful to set the time interval to 10 mins

# echo 600 > /proc/sys/net/ipv4/tcp_keepalive_time

Yes, I used something along those lines to get it working.

Hi Nicholas, 
I am also facing same issue, can you please explain that, what are the steps u follow to solve this issue.

Thanks,
Guna