Change db2 instance name

Sandeep_Sharma · #1 (**permalink**) 01-04-12, 04:33

Hi,

I have a DB2 ESE V9.5 on a aix box and it contains a instance db2inst1 which has 2 databases. I want to change the instance name from db2inst1 to db2inst5. Is it possible to change the instance name of a db2 server.

przytula_guy · #2 (**permalink**) 01-04-12, 04:52

create backup of db
create new user db2inst5
create instance for this user
restore db

wolaos123 · #3 (**permalink**) 01-04-12, 05:46

or you can use - db2relocatedb

IBM DB2 9.7 for Linux, UNIX and Windows Information Center

Sandeep_Sharma · #4 (**permalink**) 01-04-12, 06:32

i know this procedure.. but can't I simply change it without dropping like we can change the database name.

przytula_guy · #5 (**permalink**) 01-04-12, 07:11

what would be a good reason to change the instance name..

Internet Services

Web Development

Digital Marketing

Consumer Tech