Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    7

    Unanswered: Cross instance restore failing

    Hi all,

    I've two DB2 instances on the one machine (DEV and TEST) on DB2/LINUX 9.1.2. I can backup and do a re-directed restore of database successfully on the same instance, but on a cross instance restore I get the following message at the end of the restore:

    DEV.> restore database itest2 continue;
    SQL2563W The restore process has completed successfully, but one or more
    table spaces from the backup were not restored.

    All the SMS tablespaces are left in a Offline/Drop Pending state. This doesn't happen for on a same instance restore.



    Steps I'm following to get a copy of a TEST instance database called itest2 onto the DEV instance as dev1. e.g.

    BACKUP DATABASE itest2 TO "/data02/db2/backups" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

    restore database itest2
    from "/data02/db2/backups"
    taken at 20080701134322
    into dev1
    redirect without rolling forward
    without prompting;

    set tablespace containers for 0 using (path '/data01/db2/DEV/dev1/cat');
    set tablespace containers for 1 using (path '/data01/db2/DEV/dev1/tmp');
    set tablespace containers for 2 using (path '/data01/db2/DEV/dev1/usr');

    restore db itest2 continue;


    Is there something I'm missing with a cross instance restore?

    thanks
    Paul

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would check the diagnosis log to see if there is an error message. I assume that you are logged on as the instance owner for the instance you are installing to.

    Is there a permissions problem with the new instance id on that mount point?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2007
    Posts
    7
    Hi Marcus,

    The login being used for the restore is the owner of the DEV instance where the 'into' database resides.

    Yes, in the DEV db2diag.log there are file access errors on files that make up the
    database on the TEST instance.

    To the restore command I added the on ... dbpath on clauses and the restore then worked.

    e.g.

    restore database itest2
    from "/data02/db2/backups"
    taken at 20080701134322
    on /home/dev
    dbpath on /home/dev
    into dev1
    redirect without rolling forward
    without prompting;


    thanks
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •