How to reconfigure DB2 after a Windows Hostname change

16 March,2016 by Jack Vamvas

If DB2 LUW is installed on a Windows server and there is a Windows Server host name , the services supporting DB2 will not start. Some changes need to be made to allow DB2 to start.

You will see errors in Event Logs some examples may be :

The DB2 - DB2COPY3 - DB2-0 service terminated with service-specific error %%-1022.

The workaround I’ve used to allow DB2 LUW 10.1 and above is :

>> Find and open db2nodes.cfg . Using a text editor change the old host names to the  new host name

>> Open a Windows cmdline and execute:

db2extsec –r
db2extsec /a DB2ADMNS /u DB2USERS

>>Restart the server

In case you’re wondering about the purpose of db2extsec ,then the reason is there is a security feature which prohibits you from making the registry changes.   Using the commands relating to db2extsec completes similar to below

>> Open Windows cmdline and open “regedit”.

>>In regedit the following keys values need to be changes. You’ll need to change the reference to the old Windows hostname to the new Windows hostname

“HKEY_LOCAL_MACHINE\Software\IBM\DB2\GLOBAL_PROFILE\ DB2_ADMINGROUP”
“HKEY_LOCAL_MACHINE\Software\IBM\DB2\GLOBAL_PROFILE\ DB2_USERGROUP”
“HKEY_LOCAL_MACHINE\Software\IBM\DB2\GLOBAL_PROFILE\ DB2SYSTEM”

 Read More

How to grant privileges for a windows username on a new

Windows Server Uptime and Net Statistics Server - DBA DB2

 

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to reconfigure DB2 after a Windows Hostname change

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright