By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

Change Server Name on a DB2 Server

P: n/a
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 ?

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <st********@mbs.gov.on.ca> a écrit dans le message de news:
11*********************@f14g2000cwb.googlegroups.c om...
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 ?


Nov 12 '05 #2

P: n/a
You might also have to change the sqllib/db2nodes.cfg file

Nov 12 '05 #3

P: n/a
StanL wrote:
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
http://www.lueckdatasystems.com/

Remove the upper case letters NOSPAM to contact me directly.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.