Connection manager resilience
Posted in 2012
I'm trying to set up a group of Connection Managers. On the Connection Manager server sqlhosts looks like this: # Underlying Instance Connections idsmach1db_app group - - i=1 idsmach1db1_app onsoctcp idsmach1db1 idsmach1db1_app g=idsmach1db_app idsmach1db2_app onsoctcp idsmach1db2 idsmach1db2_app g-idsmach1db_app idsmach1db3_app onsoctcp idsmach1db3 idsmach1db3_app g=idsmach1db_app idsmach1db4_app onsoctcp idsmach1db4 idsmach1db3_app g=idsmach1db_app # Connection Manager Connections idsmach1_oltp group - - c=0 idsmach1_oltp_loc onsoctcp idsmach1cm1 idsmach1_oltp_loc g=idsmach1_oltp # 50010/50011 idsmach1_oltp_rem onsoctcp idsmach1cm2 idsmach1_oltp_rem g=idsmach1_oltp # 50010/50011 and the CM config file: # General Settings NAME idsmach1_cm1cm DEBUG 1 LOGFILE /opt/informix/INST1/idsmach1_cmlog SQLHOSTS local CLUSTER idsmach1db_app { INFORMIXSERVER idsmach1db1_app SLA idsmach1_oltp_loc DBSERVERS=primary FOC ORDER=SDS TIMEOUT=2 RETRY=1 } ... and that works fine. But the second I change the config file to refer to the Connection Manager group, rather than one of its members: SLA idsmach1_oltp DBSERVERS=primary I get: 22:19:15 Warning: Cannot start listener idsmach1_oltp, network error -25557 Why can I not set the SLA to look at the group, not the entries? Looking at this: http://www-01.ibm.com/support/docview.wss?uid=swg21584668, it seems that perhaps you *can't* refer to a group in the CM config file, which if true is quite counter-intuitive. Thanks Neil