Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2016
    Posts
    20

    Unanswered: Unable to connect the remote database between servers

    Please help me on below queries .


    We have two Linux servers & BOTH servers Informix software install with below IP

    10.0.0.97

    10.0.0.186 (configured name as sbt & 2 database sbthr & sbtor )


    I would like to connect & access from 10.0.0.97 to 10.0.0.186 sbthr or sbtor any of the database .

    can some one share the steps to be configure for the connectivity between both the servers

    Below are he configuration of 10.0.0.186 for your reference.

    Setup Environment

    export INFORMIXDIR=/opt/informix
    export INFORMIXSERVER=sbt
    export ONCONFIG=onconfig.sbt
    export DB_LOCALE=en_us.utf8
    export CLIENT_LOCALE=en_us.utf8
    export GL_USEGLU=1
    export PATH=$INFORMIXDIR/bin:$PATH
    export INFORMIXSQLHOSTS=/opt/informix/etc/sqlhosts


    sqlhosts

    sbt onsoctcp ip-10-0-0-186.eu-west-1.compute.internal 9088
    sbt_dr drsoctcp ip-10-0-0-186.eu-west-1.compute.internal 9089
    sbt_str onipcstr 127.0.0.1 dummy1


    onconfig files

    DBSERVERNAME sbt
    DBSERVERALIASES sbthr,sbtor



    Early response will be appreciated.

    Thanks

  2. #2
    Join Date
    May 2008
    Posts
    36
    In order to make a connection you have to enter the information from server1 into the INFORMIXSQLHOSTS of server2 and vice versa. Restart is not necessary.
    Afterwards choose "Connection->Connect" in dbaccess and you will see the the other server.
    For example, enter

    sbt onsoctcp ip-10-0-0-186.eu-west-1.compute.internal 9088

    into INFORMIXSQLHOST of server with IP 10.0.0.97.

  3. #3
    Join Date
    Dec 2016
    Posts
    20
    Thanks for the response .

    please confirm the below entry of sqlhosts of both the server .

    [informix@ip-10-0-0-97 ~]$ cd $INFORMIXDIR/etc
    [informix@ip-10-0-0-97 etc]$ cat sqlhosts

    sbt onsoctcp ip-10-0-0-186.eu-west-1.compute.internal 9088
    sbt onsoctcp ip-10-0-0-97.eu-west-1.compute.internal 9088
    sbt_dr drsoctcp ip-10-0-0-97.eu-west-1.compute.internal 9089
    sbt_str onipcstr 127.0.0.1 dummy1
    [informix@ip-10-0-0-97 etc]$
    ================================
    [informix@ip-10-0-0-186 scripttst]$ cd $INFORMIXDIR/etc
    [informix@ip-10-0-0-186 etc]$ cat sqlhosts
    sbt onsoctcp ip-10-0-0-186.eu-west-1.compute.internal 9088
    sbt_dr drsoctcp ip-10-0-0-186.eu-west-1.compute.internal 9089
    sbt_str onipcstr 127.0.0.1 dummy1

    sbt onsoctcp ip-10-0-0-97.eu-west-1.compute.internal 9088
    [informix@ip-10-0-0-186 etc]$

    Is this the right entry , please confirm

    Thanks

  4. #4
    Join Date
    May 2008
    Posts
    36
    hi,

    that looks correct to me, but it should be easily confirmed by issuing the test I described earlier with dbaccess

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •