IBM Support

Another way to move maximo DB2 database between servers.

Technical Blog Post


Abstract

Another way to move maximo DB2 database between servers.

Body

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:

  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
.......
for full list of option please see the
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0004500.html?cp=SSEPGG_10.5.0%2F3-6-2-6-103

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":""}]

UID

ibm11132005