467,189 Members | 1,318 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

Renaming an instance

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
  • viewed: 1939
Share:
4 Replies
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
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
Now I'm told it will require a renaming of the instance, database and
schema

Jul 5 '07 #4
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.

Similar topics

4 posts views Thread by Steve Jorgensen | last post: by
2 posts views Thread by snewell2003 via SQLMonster.com | last post: by
reply views Thread by Andy | last post: by
8 posts views Thread by BillCo | last post: by
3 posts views Thread by Shepherd.Travis@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.