IBM Support

Another way to move maximo DB2 database between servers.

Technical Blog Post


Another way to move maximo DB2 database between servers.


We know that there a few ways to move databases from source server to target server

1) Take a full copy and restore the entire database on target server.

2) Use Export,Import ,load ,db2look and db2move  utilities.

and a scope of this document is a DB2RELOCACTEDB   command.

This command renames a database, or relocates a database or part of a database (for example, the container and the log directory) as specified in the configuration file provided by the user. This tool makes the necessary changes to the DB2® instance and database support files

The Target database must be off line.There is an ability  to   rename objects and structures during this move

Before using the  DB2RELOCACTEDB  the following steps must be taken:

a) move the files from  from source to target  using OS  copy  or move  commands

mv /home/db2inst1/NODE000/O     /home/db2inst1/NODE0000/N

Where O - old database name and   N- new database name

b) Create the  the  ( -f)   configuration file "configfile.txt"  where the source and target names   have to be specified. It should look like this:

for full list of option please see the

Run  DB2RELOCACTEDB  command

DB2RELOCACTEDB  -f  configfile.txt

Run db2stotp , db2start and take a backup of a database on a target  server.

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]