Hi there,
Command Reference book stated for db2relocatedb command:
Copy the files/devices belonging to the databases being copied onto the
system where the new instance resides. The path names must be changed
as necessary. However, if there are already databases in the directory
where the database files are moved to, you can mistakenly overwrite the
existing sqldbdir file, thereby removing the references to the existing
databases. In this scenario, the db2relocatedb utility cannot be used.
Instead of db2relocatedb, an alternative is a redirected restore.
But I still cannot understand the difference between db2relocatedb and
redirected restore. For example,
Host: SysA, Instance: Inst1, Database: DB1, DB_PATH: /home/db2inst1
Host: SysB, Instance: Inst1, Database: DB2, DB_PATH: /home/db2inst1
I want to move DB1 from SysA to SysB, and which method should be used?
Any comments?