Can you rename a DB2 instance?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

leungb@aptea.com - 25 Feb 2005 22:04 GMT

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

Reply to this Message

Mark A - 25 Feb 2005 23:03 GMT

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

Reply to this Message

Pierre Saint-Jacques - 26 Feb 2005 22:56 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> > Or you pretty much have to backup the databases on the instance. Drop
> > it. Create another instance with a new name. Restore redirect the
[quoted text clipped - 3 lines]
> >
> Yes, you must do all those things. Cannot rename.

Reply to this Message