Backup-Restore problem

[gorros]

I have a server where I can't restore backups, even if they are taken at the same server (see command-lines below).
It is DB2 8, fixpack 10

Please, anyone who can help?

D:\>db2 create db xxx on d
DB20000I The CREATE DATABASE command completed successfully.

D:\>db2 backup db xxx to d:\x

Backup successful. The timestamp for this backup image is : 20080311163520


D:\>db2 restore db xxx from d:\x
SQL2570N A database cannot be restored on a platform that does not match the
platform on which the backup image was created.

D:\>

[sakumar9]

Interesting problem. :)

Can you give some details like platform, DB2 version etc.

One possibility is to check if there are some other images at d:\x. I am not sure of this but you can give it a try. Remove the contents from this directory and then try the BACKUP and RESTORE.

If I find something else, I will let you know. Thanks

Regards'
-- Sanjay

[sakumar9]

I tried reproducing it but it passed for me on FP16. :(

C:\Documents and Settings\Administrator\Desktop>db2 create db xxx on c:
DB20000I  The CREATE DATABASE command completed successfully.

C:\Documents and Settings\Administrator\Desktop>db2 backup db xxx to c:\x

Backup successful. The timestamp for this backup image is : 20080312123801


C:\Documents and Settings\Administrator\Desktop>db2 restore db xxx from c:\x
SQL2539W  Warning!  Restoring to an existing database that is the same as the ba
ckup image database.  The database files will be deleted.
Do you want to continue ? (y/n) y
DB20000I  The RESTORE DATABASE command completed successfully.

C:\Documents and Settings\Administrator\Desktop>db2level
DB21085I  Instance "DB2" uses "32" bits and DB2 code release "SQL08029" with
level identifier "030A0106".
Informational tokens are "DB2 v8.1.16.429", "s080111", "WR21390", and FixPak
"16".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".


C:\Documents and Settings\Administrator\Desktop>

Can you also attach the db2diag.log file. Just clean this file before reproducing the error. This will keep it smaller.

Regards
-- Sanjay