Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2007
    Posts
    49

    Unanswered: Restore the DB backup file

    Hi

    I Received the backup file from my client in the format of a zip file, and was asked to restore it on my local machine using DB2 control center.

    When i unzipped the file and stored in C ,Now the backup file exists in "C:\AM.0\DB2\NODE0000\CATN0000\20090107" with the backup file name 092929.001

    Can anybody suggest me how i can achieve this?

    Thanks in Anticipation
    Neha

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    From CONTROL CENTER you have the option to CREATE DATABASE using an existing Backup Image. Just right click on the DATABASE FOLDER and go after the options, you should be able to do that.

    You can also try RESTORE command. Search for RESTORE in the DB2 Help manual.

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    First run db2ckbkp to make sure it is a good backup image. Then look in the manual for the RESTORE command. Your database name is AM and the timestamp is 20090107092929.

    Andy

  4. #4
    Join Date
    Dec 2007
    Posts
    49
    Hi All

    Thanks for the replies , I Tried all the ways, but i get an error

    Error:
    SQL2542N No match for a database image file was found based on
    the source database alias "AM" and timestamp "20090107092929"
    provided.
    Command:
    And the command which was issued thru Control center was
    RESTORE DATABASE AM FROM "C:\AM.0\DB2\NODE0000\CATN0000\20090107" TAKEN AT 20090107092929 TO "C:" INTO AM WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

    As per the resources , the backup was taken on AIX . So i tried to restore the file even on AIX system.

    Even there i get an error

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

    and

    When i check the backup file
    # db2ckbkp 092929.001

    ERROR - Unable to migrate media header from image
    ERROR: Failed to verify media header. Cannot continue.

    And Can anyone help me understanding on what is Db2move and can it be used for restoring backup files?

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    First, I am not familiar on how windows does the naming of the backup image, but I think the restore command should be:

    RESTORE DATABASE AM FROM "C:\" TAKEN AT 20090107092929 TO "C:" INTO AM WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

    Second the output of db2ckbkp basically means that the backup image is no good.

    Third, db2move has nothing to do with backups. It is a method of copying data from one live database to another.

    Andy

Posting Permissions

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