Db2

Db2

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


#Data
 View Only

  • 1.  changing the hostname

    Posted Sat November 14, 2020 02:31 PM
    I am using db2 11.5.4 on linux and want to change the hostname in host and db2
    if I read the doc :
    4) Login as user ROOT if DB2 is on UNIX/Linux and Local Administrator on Windows. Update the DB2SYSTEM registry variable while in the instance home directory:
    • UNIX/Linux
    db2set -g DB2SYSTEM=<new hostname>
    but as root : positioned in instance home it will not find db2set so I specified
    sqllib/adm/db2set -g DB2SYSTEM=pacemkrp      and no error
    su - db2ins11
    [db2ins11@pacemkrp ~]$ db2set -all
    [i] DB2COMM=TCPIP
    [g] DB2SYSTEM=pacemkrs.localdomain
    the hostname has not changed - although I have done this before and worked
    any idea why this is not working or is there another way


    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    #Db2


  • 2.  RE: changing the hostname

    Posted Mon November 16, 2020 02:24 AM
    Hello Guy,

    did you also change the db2nodes.cfg in <db2 instance home directory>/sqllib/ and start the db2 instance?

    Best regards,
    Joachim

    ------------------------------
    Joachim Müller
    ------------------------------

    Original Message


  • 3.  RE: changing the hostname

    Posted Mon November 16, 2020 07:18 AM
    thks for the update
    yes, I did
    as I needed the instance urgently : I dropped/created the instance - cataloged the db and this was corrected
    would be good to know why  this could not be changed

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message


Related Content