Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    8

    Unanswered: Restore to different machine

    When I restore the database 9DB2 ver 6) form Machine A to MAchione B. I get the problem.

    I backup in Machine A , the backup fiel store in D:\backup\MSER.0\.....
    I copy the backup file form Machine A to Machine B and the same location

    But there is error when i restore from control center or type the command

    RESTORE DATABASE MSER FROM D: TAKEN AT 20030723152102 WITH 2 BUFFERS BUFFER 1024 WITHOUT PROMPTING

    but the following error display

    SQL2542N No match for a database image file was found based on the source database alias and timestamp provided.


    How can I do? I have install the v6 FixPak 11.
    any log file can find?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Restore to different machine

    Copy the directory MSER.0 to say, D:\backup on the targer ..

    Then issue the issue restore like

    restore database mser from d:\backup blah .. blah ..

    DB2 requires the entire directory structure and not just the file ...

    HTH

    Sathyaram

    Originally posted by peterchoy
    When I restore the database 9DB2 ver 6) form Machine A to MAchione B. I get the problem.

    I backup in Machine A , the backup fiel store in D:\backup\MSER.0\.....
    I copy the backup file form Machine A to Machine B and the same location

    But there is error when i restore from control center or type the command

    RESTORE DATABASE MSER FROM D: TAKEN AT 20030723152102 WITH 2 BUFFERS BUFFER 1024 WITHOUT PROMPTING

    but the following error display

    SQL2542N No match for a database image file was found based on the source database alias and timestamp provided.


    How can I do? I have install the v6 FixPak 11.
    any log file can find?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2003
    Posts
    8

    Re: Restore to different machine

    I have to type the full path
    d:\Backup\MSER.0\DB2\NODE0000\CATN0000\20030723
    in the command?

    RESTORE DATABASE MSER FROM d:\Backup\MSER.0\DB2\NODE0000\CATN0000\20030723 TAKEN AT 20030723152102 WITH 2 BUFFERS BUFFER 1024 WITHOUT PROMPTING

    right?




    Originally posted by sathyaram_s
    Copy the directory MSER.0 to say, D:\backup on the targer ..

    Then issue the issue restore like

    restore database mser from d:\backup blah .. blah ..

    DB2 requires the entire directory structure and not just the file ...

    HTH

    Sathyaram

  4. #4
    Join Date
    Feb 2004
    Posts
    10
    Sathyaram_s,

    We are having the same problem here...

    Db2 7.1 FP 10

    Our target machine is a new DB2 install. There are no databases currently on the machine

    We have copied the entire backup directory to the new machine as you stated. JDS_LIVE.0 (in our case)

    In CLP we are typing: (on the target machine)
    RESTORE DATABASE JDS_LIVE FROM C:\Backup\JDS_LIVE.0\DB2\NODE0000\CATN0000\2004033 0 TAKEN AT 20040330230004

    but still get the same error:
    SQL2542N No match was for a database image file was found based on the source database alias "JDS_LIVE" and timestamp "20040330230004" provided.

    what are we doing wrong ?

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Use just this

    C:\Backup\

    Cheers
    Sathyaram

    Originally posted by JDCam
    Sathyaram_s,

    We are having the same problem here...

    Db2 7.1 FP 10

    Our target machine is a new DB2 install. There are no databases currently on the machine

    We have copied the entire backup directory to the new machine as you stated. JDS_LIVE.0 (in our case)

    In CLP we are typing: (on the target machine)
    RESTORE DATABASE JDS_LIVE FROM C:\Backup\JDS_LIVE.0\DB2\NODE0000\CATN0000\2004033 0 TAKEN AT 20040330230004

    but still get the same error:
    SQL2542N No match was for a database image file was found based on the source database alias "JDS_LIVE" and timestamp "20040330230004" provided.

    what are we doing wrong ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Feb 2004
    Posts
    10
    It looks like it is working !!

    Thanks for the fast reply

Posting Permissions

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