1. Forum
  2. Usenet
  3. COMP.DATABASES.INFORMIX

  • Informix sqlhosts port numbers for aliases

    From skykt320@gmail.com@21:1/5 to All on Sun Jun 28 06:21:28 2020
    I'm using an Informix database 12.1 and I'm wondering if I should use unique port numbers for each alias. The two database servers are setup for HDR.

    onconfig.dbserver1
    DBSERVERNAME dbserver1
    DBSERVERALIASES dbserver,dbserver_dr1

    onconfig.dbserver2
    DBSERVERNAME dbserver2
    DBSERVERALIASES dbserver,dbserver_dr2

    # sqlhosts.dbserver1
    dbserver1 onsoctcp host1 50100
    dbserver2 onsoctcp host2 50100
    dbserver onsoctcp host1 50100
    dbserver_dr1 drsoctcp host1 50200
    dbserver_dr2 drscotcp host2 50200

    # sqlhosts.dbserver2
    dbserver1 onsoctcp host1 50100
    dbserver2 onsoctcp host2 50100
    dbserver onsoctcp host2 50100
    dbserver_dr1 drsoctcp host1 50200
    dbserver_dr2 drscotcp host2 50200

    The same alias "dbserver" is needed on both servers so SQL statements using 'from database@dbserver:table' work. Is there any performance advantage in using distinct port numbers for aliases? In my setup each server is listening on the same port that it
    makes an outgoing connection to the primary/secondary HDR.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)