Is it possible to have db2 alternate restore on different system with a
From aarti.karve@gmail.com@21:1/5 to All on Wed Sep 28 23:56:31 2016
Prod db (source db2) : hosted on linux 6.X : installation : /home/db2inst1
Dev db (target db2) : hosted on linux 6.X : installation :/home/db2/db2inst1
Our requirement is to perform an alternate db2 restore from Sourcedb2 (/home/db2inst1) to target db2 (/home/db2/db2inst1).
Is such a restore supported by db2 as we are seeing following error?
SQL1277W A redirected restore operation is being performed. During a table space restore, only table spaces being restored can have their paths reconfigured. During a database restore, storage group storage paths and DMS table space containers can be reconfigured.
DB20000I The RESTORE DATABASE command completed successfully.
[db2inst1@XXX scripts]$ db2 restore db sample continue
SQL1051N The path "/home/db2inst1" does not exist or is not valid. SQLSTATE=57019