How to continue a load from cursor activity over brief network down time [Closed]

Harishkumar .Pathangay

How to continue a load from cursor activity over brief network down time [Closed]

hi,

this is a similar question as the below thread.

https://www.idug.org/p/fo/st/thread=48743

here I have a database in rhel server. I have another database in ubuntu server, both over a network.

I am loading from cursor on a table rhel server to database ubuntu server. it is all fine loading, no issues.

the question is how to make load from cursor resilient to brief network outages. suppose network goes down for 1.5 minutes, after that it comes back. but load from cursor fails with socket error. 

it is tolerating only less than a minute of network down time. how to configure this limit.

please let me know even if it is a os level setting related to tcpip sockets. I am also searching tcp socket time out in google. this is for learning purposes only. 

thanks,

harish pathangay

Edited By:
Harishkumar .Pathangay[Organization Members] @ Feb 16, 2019 - 11:16 AM (Asia/Calcutta)

Harishkumar .Pathangay

RE: How to continue a load from cursor activity over brief network down time
(in response to Harishkumar .Pathangay)
hi,
the following error is observed when ever there is down time briefly.
SQL30081N  A communication error has been detected. Communication protocol
being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location
where the error was detected: "192.168.56.109".  Communication function
detecting the error: "recv".  Protocol specific error code(s): "104", "*",
"0".  SQLSTATE=08001
SQL30081N  A communication error has been detected. Communication protocol
being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location
where the error was detected: "192.168.56.109".  Communication function
detecting the error: "recv".  Protocol specific error code(s): "104", "*",
"0".  SQLSTATE=08001
thanks,
harish p

Harishkumar .Pathangay

RE: How to continue a load from cursor activity over brief network down time
(in response to Harishkumar .Pathangay)

hi,

please consider issue closed.

By Setting DB2TCP_SERVER_KEEPALIVE_TIMEOUT=240, I was able to load from cursor on a remote database even if there is network down time of 2 minutes. Since 4 minutes of keep alive time out is there from server side.

thanks,

harish pathangay

Harishkumar .Pathangay

RE: How to continue a load from cursor activity over brief network down time [closed]
(in response to Harishkumar .Pathangay)

please consider issue closed.