Rename a DB2 database

Rename a DB2 database with these instructions. 1.) Create a configuration file, e.g MYCONFIG.CFG: DB_NAME=OLDDB,NEWDB DB_PATH=provide the path INSTANCE=provide the instance NODENUM=0 2.) Save the configuration file as relocate.cfg 3.) use the following command to make the changes to the database files: db2relocatedb -f relocate.cfg DB2 database rename is straightforward. Ref:Jack Vamvas(http://www.dba-db2.com) Read more →