1. Forum
  2. Usenet
  3. COMP.DATABASES.IBM-DB2

  • Is it possible to have db2 alternate restore on different system with a

    From [email protected]@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


    Thanks
    Aarti

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)