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

Renaming an instance

P: n/a
I am running DB2 LUW 8.2.5 on AIX 5.3

I am being asked to rename an instance in Production which contains
several databases.
I am being told it would be difficult to shut the instance down.

My thoughts would be to create a new instance then do an export/import
on the databases into the new instance.

Any thoughts on the best way to go about this would be appreciated.

Thanks
GL

Jul 5 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
datapro01 wrote:
I am running DB2 LUW 8.2.5 on AIX 5.3

I am being asked to rename an instance in Production which contains
several databases.
I am being told it would be difficult to shut the instance down.

My thoughts would be to create a new instance then do an export/import
on the databases into the new instance.

Any thoughts on the best way to go about this would be appreciated.

Thanks
GL
Create new instance.

For each database X:
Uncatalog database X from old instance
Catalg database X in new instance
Jan M. Nelken
Jul 5 '07 #2

P: n/a
On Jul 5, 7:48 am, "Jan M. Nelken" <Unknown.U...@Invalid.Domain>
wrote:
datapro01 wrote:
I am running DB2 LUW 8.2.5 on AIX 5.3
I am being asked to rename an instance in Production which contains
several databases.
I am being told it would be difficult to shut the instance down.
My thoughts would be to create a new instance then do an export/import
on the databases into the new instance.
Any thoughts on the best way to go about this would be appreciated.
Thanks
GL

Create new instance.

For each database X:
Uncatalog database X from old instance
Catalg database X in new instance

Jan M. Nelken
I understand what you are saying.
Do you think the db2relocatedb command would be a viable option?

Thanks
Gerry

Jul 5 '07 #3

P: n/a
Now I'm told it will require a renaming of the instance, database and
schema

Jul 5 '07 #4

P: n/a
On Jul 5, 9:05 am, datapro01 <datapr...@yahoo.comwrote:
Now I'm told it will require a renaming of the instance, database and
schema
Problem solved.
Thanks

Jul 6 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.