The Home of C&P Software on the Web

Rename a DB2 Database

Did you ever need to rename a database to suit a new environment or just because it's current name was not appropriate well here is how to do that with a db2 v8.1 database.  This can also be used to move the DB from one location to another and one instance to another, etc,.... you get the picture.  Read the docs for more options and capabilities.

1. Create a configuration file:
2. Save the configuration file as relocate.cfg  
3. use the following command to make the changes to the databasefiles:  db2relocatedb -f relocate.cfg

Here is the relocate.cfg file:

DB_NAME=OLDDB,NEWDB
DB_PATH=provide the path
INSTANCE=provide the instance
NODENUM=0