Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Duplicate DBSERVERALIAS

    Posted 06/26/24 10:05 AM

    Hi,

    The Admin's Guide declares,

    Each database server across all of your associated networks must have a unique database server name.

    Nevertheless, our primary and RSS are sharing the same name in DBSERVERALIASES.

    What is a risk of having duplicate dbserver names?

    BTW, online.log is filled with messages,

    Registration of Connection Manager %s is rejected because its name is not unique.

    What a chance is it results from duplicate names?



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------


  • 2.  RE: Duplicate DBSERVERALIAS

    Posted 06/26/24 10:26 AM
    Hi,

    Either you are connecting via connection manager or by a floating DBSERVERNAME.
    Both is not compatible.
    Connection manager needs to have distinguished names of the connected engines and, for automatic failover
    a HA_ALIAS declaration, which points to the network based connection.
    You could also have a setup where a server name is shared and the IP is migrated from one server to another,
    and then the listener is activated, when the primary instance is losts. 
    This would be done without connection manager (manually or with support of an external tool like keepalived).
    But this behaviour is not compatible with connection manager.

    So what would be the purpose of the common DBSERVER name in a connection manager ruled environment ?

    Best,

    MARCUS HAARMANN





  • 3.  RE: Duplicate DBSERVERALIAS

    Posted 06/26/24 10:54 AM

    Dennis:

    As long as each server does not know about the duplicated connection name from the other servers in the cluster you are golden. So, just do not include that name in the SQLHOSTS files on the other servers, only on the local server's host about itself.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 4.  RE: Duplicate DBSERVERALIAS

    Posted 06/26/24 10:59 AM

    If you are setting up connection manager I would also suggest you set USEALIASES=OFF, that way it won't look at the sqlhosts file for any additional listeners. 



    ------------------------------
    Thomas Beebe
    Vice President
    xDB Systems, Inc
    Woodbridge
    5713399029
    ------------------------------



  • 5.  RE: Duplicate DBSERVERALIAS

    Posted 06/26/24 12:28 PM

    As we got down to Connection Manager, what is a reasonable value for WORKERS which defaults to 4? How can I decide that 4 is not enough?



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------



Related Content