DRDA issue via Connection manager
Posted in 2016
Topics: High Availability & Replication, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues, Clustering, Grid & MACH11
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,