Connection Manager Redundancy with DRDA Connection
Posted in 2019
I have two Connection managers configured with two SLA entries using REDIRECT, one for the native SQLI connection (onsoctcp) and one for DRDA connection (drsoctcp) connection to just on IDS for testing. Everything looks good between the connection managers and the IDS. When I test my .net apps using the SQLI connection fail over to the 2nd connection manager works fine, but when I test with the DRDA connection it seems to just hang when opening the connection using the fail over connection manager. When looking at the log for connection manager I see the connection getting redirected. I do not see any errors either in the connection manager log or the IDS log. After about 5 mins or so the receive this error in my app: "ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "<server ip>". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001"