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 ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial