Understanding DB2: Learning Visually with Examples (2nd Edition)

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.

Related

Категории