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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables