Topic
  • 4 replies
  • Latest Post - ‏2014-09-18T08:26:38Z by andreasl
SKB2005
SKB2005
3 Posts

Pinned topic Connection Manager Requirements

‏2014-09-17T15:00:02Z | connection informix manager

We have 2 standalone IDS 12.10 servers synchronized with each other using our own app. We are not using Informix provided ER,HDR,RSS,SDS etc for data replication. No clustering either.

 

Can we use connection manager in above scenario?

  • andreasl
    andreasl
    30 Posts

    Re: Connection Manager Requirements

    ‏2014-09-17T15:19:23Z  

    Hello,

    I'd say you can, only not for cluster fail-over arbitrating, so as a pure "connection manager" doing load balancing or SLA based connection directing.

    HTH,

     Andreas

  • SKB2005
    SKB2005
    3 Posts

    Re: Connection Manager Requirements

    ‏2014-09-17T16:04:39Z  
    • andreasl
    • ‏2014-09-17T15:19:23Z

    Hello,

    I'd say you can, only not for cluster fail-over arbitrating, so as a pure "connection manager" doing load balancing or SLA based connection directing.

    HTH,

     Andreas

    Appreciate your response, I will do further reading and try to set something up in the lab and post my queries if I have any. I am sure I will have plenty of them :).

  • SKB2005
    SKB2005
    3 Posts

    Re: Connection Manager Requirements

    ‏2014-09-18T04:53:07Z  
    • SKB2005
    • ‏2014-09-17T16:04:39Z

    Appreciate your response, I will do further reading and try to set something up in the lab and post my queries if I have any. I am sure I will have plenty of them :).

    I have 2 lab servers with hostname lab1 and lab2. Both server same version of Informix installed on similar hardware/OS. I took level 0 of lab1 and restored on lab2.

    When I am starting the connection manager,log file shows the error message "Cannot connect to server lab1_shm with ipcshm, Connection Manager stopped"

     Following is the configuration files info:

    #/etc/host of both lab1 and lab2

    192.168.2.128           lab1
    192.168.2.130           lab2

    #/home/Informix/etc/sqlhosts of  lab1

    lab1_shm        onipcshm        lab1    9910
    lab1_tcp          onsoctcp         lab1    9910
    lab2_tcp          onsoctcp         lab2    9910

    sla_cm1           onsoctcp        lab1     9911
    sla_cm2           onsoctcp        lab1     9912
     

     

    #/home/Informix/etc/sqlhosts of both lab2

    lab2_shm        onipcshm        lab2    9910
    lab1_tcp          onsoctcp         lab1    9910
    lab2_tcp          onsoctcp         lab2    9910

    sla_cm1           onsoctcp        lab1     9911
    sla_cm2           onsoctcp        lab1     9912

     

    #Connection Manager config on lab1

    NAME cm_lab1
    LOG 1
    DEBUG 1
    LOGFILE $INFORMIXDIR/tmp/cm_lab1.log

    SERVERSET  lab_servers
    {

       INFORMIXSERVER lab1_tcp,lab2_tcp

       SLA sla_cm1 DBSERVERS=lab1_tcp,lab2_tcp SERVICE=9911
       SLA sla_cm2 DBSERVERS=lab2_tcp,lab1_tcp SERVICE=9912

    }

     


           

  • andreasl
    andreasl
    30 Posts

    Re: Connection Manager Requirements

    ‏2014-09-18T08:26:38Z  
    • SKB2005
    • ‏2014-09-18T04:53:07Z

    I have 2 lab servers with hostname lab1 and lab2. Both server same version of Informix installed on similar hardware/OS. I took level 0 of lab1 and restored on lab2.

    When I am starting the connection manager,log file shows the error message "Cannot connect to server lab1_shm with ipcshm, Connection Manager stopped"

     Following is the configuration files info:

    #/etc/host of both lab1 and lab2

    192.168.2.128           lab1
    192.168.2.130           lab2

    #/home/Informix/etc/sqlhosts of  lab1

    lab1_shm        onipcshm        lab1    9910
    lab1_tcp          onsoctcp         lab1    9910
    lab2_tcp          onsoctcp         lab2    9910

    sla_cm1           onsoctcp        lab1     9911
    sla_cm2           onsoctcp        lab1     9912
     

     

    #/home/Informix/etc/sqlhosts of both lab2

    lab2_shm        onipcshm        lab2    9910
    lab1_tcp          onsoctcp         lab1    9910
    lab2_tcp          onsoctcp         lab2    9910

    sla_cm1           onsoctcp        lab1     9911
    sla_cm2           onsoctcp        lab1     9912

     

    #Connection Manager config on lab1

    NAME cm_lab1
    LOG 1
    DEBUG 1
    LOGFILE $INFORMIXDIR/tmp/cm_lab1.log

    SERVERSET  lab_servers
    {

       INFORMIXSERVER lab1_tcp,lab2_tcp

       SLA sla_cm1 DBSERVERS=lab1_tcp,lab2_tcp SERVICE=9911
       SLA sla_cm2 DBSERVERS=lab2_tcp,lab1_tcp SERVICE=9912

    }

     


           

    Hi,

    can't use shared memory or streams connection types (ipcshm or ipcstr) for CM, only allows tcp (soctcp).

    Now you're not using any *_shm name in your CM configuration, so where's it taking this from?

    Did you possibly set your DBSERVERNAME to lab1_shm ?  If so, rather put lab1_tcp there and the shm port to DBSERVERALIASES.


    Also check INFORMIXSERVER env var setting and see whether it makes a difference if this points to tcp port.

    Cheers,

     Andreas