09 June, 2011

How to change hostname on a DB2 Server

Hello!

Several times, when I'm building a new demo VMWare server, I realize that I've forgot to specify the VMWare hostname after already installed DB2... In those occasions, the following link, that explains how to change hostname on a DB2 Server is very useful:

https://www-304.ibm.com/support/docview.wss?uid=swg21258834&wv=1

Basically, in my case, since I usually don't have any databases or configurations yet, the following steps are enough:

1) Login as the dasadm user and stop the DB2 Administration Server (DAS):

                 db2admin stop

2) Login as the instance owner and Stop the DB2 instance:

                 db2stop

3) Change the server's hostname.

4) Update the DB2SYSTEM registry variable:db2set -g DB2SYSTEM=<new hostname>

5) In the db2nodes.cfg file (which is in the sqllib db2 folder) change <current hostname> to <new hostname>.

Cheers!

No comments: