Pages

Thursday, December 20, 2012

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.

Posted by Bharath at
Labels: , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)