SQL1042C - hostname changed on db2 server windows/unix

1.       Run the following commands:

·         db2admin stop

·         db2stop

2.       The same hostname will be repeated twice on a single line in the db2nodes.cfg file. 

*Note that, only DB2 ESE has a db2nodes.cfg file. If you are running other editions (WorkGroup Server, or Personal Edition) then you can skip this step and go to 3rd step.

File Location:

UNIX/Linux:
db2 instance home directory/sqllib/db2nodes.cfg

All Windows flavors running DB2 v8 and v9.1:
Program Files\IBM\SQLLIB\DB2\db2nodes.cfg 

Windows XP and 2003 running DB2 v9.5:
Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY\DB2\db2nodes.cfg

NOTE: Application Data is a hidden folder

Windows Vista and later operating systems: ProgramData\IBM\DB2\DB2COPY\DB2\db2nodes.cfg

3.       Use the db2extsec command to update the authorities for the installation-defined groups DB2ADMNS and DB2USERS with new hostname. 

                           

          For example the new hostname = 'newhostname'

                           

     Run the following command:

•   db2extsec -a newhostname\DB2ADMNS -u newhostname\DB2USERS

4.       Update the DB2 registry variables using db2set command. Run the following commands:

·         db2set db2accountname=newhostname\db2admin

·         db2set db2instowner=newhostname

·         db2set db2system=newhostname

Suggestions are always welcome..!  Without signing also you can send your comments.