Informix Connection Manager - USEALIASES
Posted in 2013
I have 3 VMs setup - 1 w/Connection Manager, and the other 2 being a HDR pair.
I'm noticing in the logs that CM tries to use all the DBSERVERALIASES that I
have defined in the HDR pair ONCONFIG. Under the CM CONFIG, I have
USEALIASES=OFF; so I'm a little confused as to why I am seeing all these other
services being called by the CM.
CM CONFIG -
CLUSTER q3sv00_grp
{
INFORMIXSERVER q3sv00a_cm,q3sv00b_cm
SQLHOSTS local
SLA dd_inst_3 DBSERVERS=primary,HDR MODE=REDIRECT POLICY=WORKLOAD
USEALIASES=OFF WORKERS=6
SLA dd_read_3 DBSERVERS=HDR,primary MODE=REDIRECT POLICY=WORKLOAD
USEALIASES=OFF WORKERS=4
FOC ORDER=primary,HDR TIMEOUT=120 RETRY=1
CMALARMPROGRAM /opt/hd/db/bin/ifx_cmsm_alarm.ksh
}
CM SQLHOSTS -
q3sv00_grp group - - i=24
q3sv00a_cm onsoctcp cpliqab5 informix43 g=q3sv00_grp
q3sv00b_cm onsoctcp cpliqab6 informix43 g=q3sv00_grp
dd_inst_3 onsoctcp cpliqadd informix86
dd_read_3 onsoctcp cpliqadd informix87
LOG -
23:05:13 DEBUG[TID47946678294848]:adding q3sv00a alias q3sv00a_hdr with
protocol onsoctcp 1 [cmsm_server.ec:cmsm_add_dbaliases:2390]23:05:13 DEBUG[TID47946680396096]:adding q3sv00b alias q3sv00b_tcp with
protocol onsoctcp 1 [cmsm_server.ec:cmsm_add_dbaliases:2390]23:05:13 DEBUG[TID47946678294848]:adding q3sv00a alias q3sv00a_cm with
protocol onsoctcp 1 [cmsm_server.ec:cmsm_add_dbaliases:2390]23:05:13 DEBUG[TID47946680396096]:failed to convert service "q3sv00b_shm" to a
port. -1 [cmsm_server.ec:cmsm_convert_service_to_port:304]
Any ideas?