niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » IBM DB2
Can you rename a DB2 instance?
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
Pierre Saint-Jacques
*nix forums Guru Wannabe


Joined: 29 May 2005
Posts: 217

PostPosted: Sat Feb 26, 2005 9:56 pm    Post subject: Re: Can you rename a DB2 instance? Reply with quote

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" <nobody@nowhere.com> a écrit dans le message de
news:gtCdnV8l2IEzM4LfRVn-sw@comcast.com...
Quote:
leungb@aptea.com> wrote in message
news:1109369186.748731.254090@g14g2000cwa.googlegroups.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.

Back to top
Vincent M
*nix forums Guru


Joined: 22 Feb 2005
Posts: 1332

PostPosted: Fri Feb 25, 2005 10:03 pm    Post subject: Re: Can you rename a DB2 instance? Reply with quote

<leungb@aptea.com> wrote in message
news:1109369186.748731.254090@g14g2000cwa.googlegroups.com...
Quote:
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.
Back to top
leungb@aptea.com
*nix forums beginner


Joined: 25 Feb 2005
Posts: 1

PostPosted: Fri Feb 25, 2005 9:06 pm    Post subject: Can you rename a DB2 instance? Reply with quote

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
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Thu Jan 08, 2009 3:46 am | All times are GMT
navigation Forum index » Databases » IBM DB2
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts database Share Memory Limit (2 GB ) in a Instance is tota... sadanjan@gmail.com IBM DB2 0 Fri Jul 21, 2006 12:57 pm
No new posts error when rename pointer names ehabaziz2001@gmail.com C 3 Mon Jul 17, 2006 10:09 pm
No new posts rename multiple remote files in sftp process. s4shoaib@gmail.com shell 1 Mon Jul 17, 2006 6:43 pm
No new posts having a problem with an instance of a method. john.mcginnis@comcast.net python 1 Fri Jul 14, 2006 4:06 pm
No new posts Trying to connect to an Oracle instance... Spendius PostgreSQL 4 Thu Jul 13, 2006 12:46 pm

Personal Car Finance | 0 Credit Cards | Dutch Bodybuilding Forums | AdSense Optimization Tutorials | Loans
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.1125s ][ Queries: 20 (0.0328s) ][ GZIP on - Debug on ]