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

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.

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

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?

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