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.  Changing RSS IP

    Posted Wed January 10, 2024 12:35 AM

    Hello

    We need to change IP on our RSS server.

    Is it possible to reconnect with the main server without resetting informix (main server) ?

    Thanks



    ------------------------------
    Samuel
    ------------------------------


  • 2.  RE: Changing RSS IP

    Posted Wed January 10, 2024 06:22 AM

    You can do this on the primary:

    onmode -wm NS_CACHE='host=0,service=0,user=900,group=0,sqlhosts=0'

    Wait about 30 seconds to insure that the DNS has been polled, then set it back to what it was (these are the defaults):

    onmode -wm NS_CACHE='host=900,service=900,user=900,group=900,sqlhosts=900'

    That should allow the server to recognize the secondary at the new IP.

    Art



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



  • 3.  RE: Changing RSS IP

    Posted Wed January 10, 2024 07:22 AM

    Hi,

    We don't use DNS but /etc/hosts

    that could work ?



    ------------------------------
    Samuel To
    ------------------------------



  • 4.  RE: Changing RSS IP

    Posted Wed January 10, 2024 07:31 AM

    It should work, yes.

    Art



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



  • 5.  RE: Changing RSS IP

    Posted Wed January 10, 2024 07:38 AM

    Thanks



    ------------------------------
    Samuel To
    ------------------------------



  • 6.  RE: Changing RSS IP

    Posted Thu January 11, 2024 03:53 AM
    Edited by Dennis Melnikov Mon January 15, 2024 09:31 AM

    Hi,

    Do not forget to update the RSS' IP in primary's /etc/hosts.equiv, if you use it, and if it contains IP, not name.



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



  • 7.  RE: Changing RSS IP

    Posted Sun January 14, 2024 12:43 AM

    OK

    Thanks



    ------------------------------
    Samuel To
    ------------------------------