Can you rename a DB2 instance?

leungb

Or you pretty much have to backup the databases on the instance. Drop
it. Create another instance with a new name. Restore redirect the
backed up database onto the new instance.

Bill

Nov 12 '05 #1

Subscribe Post Reply

6181

Mark A

<le****@aptea.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Or you pretty much have to backup the databases on the instance. Drop
it. Create another instance with a new name. Restore redirect the
backed up database onto the new instance.

Bill

Yes, you must do all those things. Cannot rename.

Nov 12 '05 #2

Pierre Saint-Jacques

Couldn't one create the new instance and then use the db2relocatedb command
to achieve the same result.
If the db's are large, one might save a lot of space and time????
No?, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Mark A" <no****@nowhere.com> a écrit dans le message de
news:gt********************@comcast.com...

<le****@aptea.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Or you pretty much have to backup the databases on the instance. Drop
it. Create another instance with a new name. Restore redirect the
backed up database onto the new instance.

Bill

Yes, you must do all those things. Cannot rename.

Nov 12 '05 #3

Similar topics

rename server when DB2 installed

by: Alex | last post by:

Hi, We have UDB 7.2 running on window 2000 server name SERVERDB2UDB01(example) Until we move to version 8 we want to move our production on another sever Steps we want to do 1. install...

DB2 Database

Tree Node Rename Performance Problem

by: Saradhi | last post by:

Hi All, Here I am facing a performance problem with the TreeView Node renaming. I am displaying a hierarchy Data in a treeview in my Windows C# Application. My tree view represents an...

C# / C Sharp

Check and rename file variable

by: jez123456 | last post by:

Hi, Iâ€™ve written a c# program to compact certain msaccess databases. The way this works is to compact say C:\test1.mdb to C:\temp.mdb, then delete C:\test1.mdb and rename C:\temp.mdb as...

C# / C Sharp

os.rename copies when old is in-use - is this deliberate?

by: Tony Meyer | last post by:

On Windows, if I do os.rename(old, new) where old is a file that is in-use (e.g. python itself, or a dll that is loaded), I would expect that an error would be raised (e.g. as when os.remove is...

Python

Rename all method names in an assembly

by: Caroline | last post by:

I have a CF app and I haven't found a decent obfuscator for it. I want to write a simple obfuscator, that replaces variables and methods names. Is there any way to rename all method names returned...

C# / C Sharp

Rename a project, with .sln, etc.

by: _DD | last post by:

Is there any easy way to rename an entire project? I'd like to change everything: folder, sln file, etc.

C# / C Sharp

Help with rename and unlink script please

by: Dynamo | last post by:

I am trying to upload a file and then rename the file as something else. Everything worked fine unless the renamed filename already existed. So I added some extra code to check if the filename...

PHP

Long query rollback - can I rename the table?

by: cheesey_toastie | last post by:

I have a long query which I have set off and would like to stop, and rename one of the tables used. My query is due to my lack of understanding of the underlying structure of MSSQL-Server... ...

Microsoft SQL Server

Rename Default Instance Name SQL Server 2005

by: CK | last post by:

We have a server with Sql Server 2000 on it. We installed Sql Server 2005 on the same box. It was named SERVERNAME\SQL2005. What I need to do is basically decommision the Sql Server 2000 server and...

Microsoft SQL Server

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

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...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

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...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

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$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

How to build RAID in BIOS?

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...

Computer Hardware