Learning Visually with Examples [Electronic resources]

12.7. The db2relocatedb Utility

The

db2relocatedb utility renames a database and relocates a database or part of a database you specify in the configuration file. This tool makes the necessary changes to the DB2 instance and database files.

You can alter the following properties of a database using the

db2relocatedb utility:

• The database name

• The instance it belongs to

• The database directory

• The database partition number

• The log directory (if it does not reside in the database directory)

• The location of table space containers (if they do not reside in the database directory)

The syntax for the db2relocatedb command is

db2relocatedb f  
configuration_file_name 

The format of the configuration file is

DB_NAME=
oldName,newName 
DB_PATH=
oldPath,newPath 
INSTANCE=
oldInst,newInst 
NODENUM=
nodeNumber 
LOG_DIR=
oldDirPath,newDirPath 
CONT_PATH=
oldContPath1,newContPath1 
CONT_PATH=
oldContPath2,newContPath2 
...

If the

sample database belongs to instance db2inst1 and was created under /data, to rename the

sample database to

sample1 , edit a configuration file as follows and run the

db2relocatedb command using this file:

DB_NAME=SAMPLE,SAMPLE1
DB_PATH=/data
INSTANCE=db2inst1

To move the

sample database from the instance

db2inst1 on path /data to instance

db2inst2 on the same path, do the following:

• Move all the files in /data/db2inst1 to /data/db2inst2

• Edit a configuration file as follows and run

  db2relocatedb using this file:

  DB_NAME=SAMPLE
  DB_PATH=/data
  INSTANCE=db2inst1, dn2inst2
  

If the

sample database belongs to instance

db2inst1 , was created under /data, and has a SMS table space container /home/db2inst1/ts1 must be moved to /home/db2inst1/ts/ts1, do the following:

• Copy all the files in /home/db2inst1/ts1 to /home/db2inst1/ts/ts1.

• Edit a configuration file and run

  db2relocatedb using this file:

  DB_NAME=SAMPLE
  DB_PATH=/data
  INSTANCE=db2inst1
  CONT_PATH=/home/db2inst1/ts1,/home/db2inst1/ts/ts1
  

Refer to the file

Command_and_SQL_Examples.pdf included with the CD-ROM accompanying this book for more examples on how to use

db2relocatedb .