As i was continuously getting the following error, do we have option like auto reconnect in Additional JDBC Parameters.
[FATAL]: local_project.j_sample_0_1.j_Sample - tAsyncOut_tVerticaOutput_1 An existing connection was forcibly closed by the remote host
org.netezza.error.NzSQLException: An existing connection was forcibly closed by the remote host
You probably have to change tcp_keepalive_time parameter to avoid a connection close while your process is waiting for a response from the db server.
The following command set the keppalive parameter to 30 minutes
echo 1800 > /proc/sys/net/ipv4/tcp_keepalive_time
You may refer to this post from Vertica forum.
As per my understanding to your comment we need to change it in the server where the Netezza was installed.If i am correct. Please correct me if i am wrong.
You are right.
Also, as the result is not garanted, save the current value for tcp_keepalive_time to be able to restore it in case the problem is not solved with that.
In case of multi-nodes, do the same thing for each node.
Is there any update for your tcp_keepalive_time implement?