473,378 Members | 1,391 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Change Server Name on a DB2 Server

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
3 3864
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
You might also have to change the sqllib/db2nodes.cfg file

Nov 12 '05 #3
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: steven virnig | last post by:
A server with SQL 2000 installed is moving to a new physical location. Our company standards mean that the name of the server and the IP address of the server will change also. This SQL instance...
3
by: Hmmm... | last post by:
I need to change the name of the SQL Server on my development machine. My client's server name is "Server1". My development server name is "MachineName1\ServerTest". I am writing a Visual...
2
by: gdabbara | last post by:
Hi, We have a situation where we want to move our current database server to a different hardware and rename the server. If we change the Physical server name, do we have to go thru the whole...
2
by: Amanda | last post by:
From a guy in Microsoft newsgroups: | In *comp.databases.ibm-db2* there are always IBM guys | from the Toronto labs on line.Post with the | -for the love of god please help- | line...
4
by: rcmail14872 | last post by:
I have MS SQL Server 2000 evaluation version on my desktop PC. I have the SQL Server client tools (only) on the laptop. The two computers are networked. I had an Access MDB database on my laptop,...
0
by: yoshra | last post by:
i want to edit form and submit (post) it to another server. the name value contain char that cannot be inisde varible name in .net "xxx" so i gave those inputtypehidden diffrent name and...
2
by: SimonZ | last post by:
When I run my application in debug mode, the url is always localhost: http://localhost/project/default.aspx I would like that url would be : http://myCompName/project/default.aspx If I manually...
1
by: Lyners | last post by:
What I need - To retrieve the server name that the ASP application is running on. Why - Our current intranet is on a network where we have users that are on a domain and some that are not. Using...
6
by: craigkenisston | last post by:
How to change database name on the fly? I have an asp.net application in which a user connects to a sql server, where there's a centralized database with the users table and general settings....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.