DRDA issue via Connection manager
Hi Gurus,
Need help in coniguring the Connection Managers using DRDA. We've already
setup but it's failing. Can someone please analyze the below configuration we
used?
Client sqlhosts configuration
======================
# INFORMIXSERVER
ifx_cluster group - - i=10,e=svru2bqaqtdb02_tcp
svru2aqaqtdb01_tcp onsoctcp 10.11.10.138 49000 g=ifx_cluster
svru2bqaqtdb02_tcp onsoctcp 10.11.14.214 49000 g=ifx_cluster
# RW for Applications
ifx_oltp group - - i=30,c=1
svru2aqtcm01_oltpdr drsoctcp 10.11.18.181 49001 g=ifx_oltp
svru2bqtcm02_oltpdr drsoctcp 10.11.20.112 49002 g=ifx_oltp
# RO
ifx_report group - - i=40,c=1
svru2aqtcm01_repodr drsoctcp 10.11.18.181 49003 g=ifx_report
svru2bqtcm02_repodr drsoctcp 10.11.20.112 49004 g=ifx_report
==================
Client cmsm configuration
==================
NAME svru2aqtcm01
LOG 1
DEBUG 0
LOGFILE ${INFORMIXDIR}/log/cmsm.svru2aqtcm01.log
CLUSTER ifx_cluster
{
INFORMIXSERVER svru2aqaqtdb01_tcp,svru2bqaqtdb02_tcp
SLA svru2aqtcm01_oltpdr DBSERVERS=primary
SLA svru2aqtcm01_repodr DBSERVERS=HDR
FOC ORDER=HDR PRIORITY=1
#FOC ORDER=DISABLED
CMALARMPROGRAM ${INFORMIXDIR}/etc/cmalarmprogram.sh
}
==============================
##SERVER SIDE1:
onconfig
NETTYPE drsoctcp,1,150,NETDBSERVERALIASES svru2aqaqtdb01_drda
#demo_on onipcshm on_hostname on_servername
svru2aqaqtdb01_tcp onsoctcp svru2aqaqtdb01.qabox.test.com 49000
svru2aqaqtdb01_drda drsoctcp svru2aqaqtdb01.qabox.test.com 49005
svru2aqaqtdb01_shm onipcshm svru2aqaqtdb01.qabox.test.com 9098
svru2bqaqtdb02_tcp onsoctcp 10.11.14.214 49000
=========================
###SERVER SIDE 1:
onconfig
NETTYPE drsoctcp,1,150,NETDBSERVERALIASES svru2aqaqtdb01_drda
###SERVER SIDE 2:
onconfig
NETTYPE drsoctcp,1,150,NETDBSERVERALIASES svru2bqaqtdb02_drda
I am using informix-clientsdk-3.70-FC7W3.LINUX and
CSDK_4.10.FC4W1_LIN-x86_64_IFix csdk but it behaves the same. DB version is
12.10.FC6AEE and OS is Linux 2.6.32-573.7.1.el6.x86_64.
appreciate if someone can take a look.
Thanks,