Board index » database » Change Server Name on a DB2 Server

Change Server Name on a DB2 Server

2005-07-29 12:51:39 AM
I need to change the Server Name on a DB2 Server running in Windows. Do
I have to rebuild the server and restore all the databases ?
-
 

Re:Change Server Name on a DB2 Server

No. You need to: db2set DB2SYSTEMNAME=NEWNAME
You will have to review how your users connect to that server as their node
directories will point to a non existing name.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"StanL" <stan.leung@mbs.gov.on.ca>a écrit dans le message de news:
1122569499.169504.98260@f14g2000cwb.googlegroups.com...
Quote
I need to change the Server Name on a DB2 Server running in Windows. Do
I have to rebuild the server and restore all the databases ?

-

Re:Change Server Name on a DB2 Server

You might also have to change the sqllib/db2nodes.cfg file
-

Re:Change Server Name on a DB2 Server

StanL wrote:
Quote
I need to change the Server Name on a DB2 Server running in Windows. Do
I have to rebuild the server and restore all the databases ?
Check the thread "Changing SPN_NAME / server name with DB2 6.1" in this group from 7/22 for the full details on the server side change.
--
Michael Lueck
Lueck Data Systems
www.lueckdatasystems.com/
Remove the upper case letters NOSPAM to contact me directly.
-