up vote 1 down vote favorite
share [g+] share [fb]

I need to dump a couple of databases from DB2 for Mac and DB2 for Linux and then import the databases to DB2 for Windows. Unfortunately, when I try the standard backup and restore I get the following error:

SQL2570N An attempt to restore on target OS "NT-32" from a backup created on source OS "?" failed due to the incompatability of operating systems or an incorrect specification of the restore command. Reason-code: "1".

I've seen references to DB2 needing an IXF dump and import, but I can't find any solid information about how to do this without dozens of other steps.

Any hints on how to do this in the least painful manner?

link|improve this question
1  
You mean that question is a dupe of this one. This one was asked first. – Pridkett Jan 20 '10 at 20:06
You are right. So for the records, have a look at the duplicate of this question for the answer. ;) – Peter Schuetze Jan 22 '10 at 19:09
feedback

2 Answers

up vote 0 down vote accepted

Since it's not possible to say a comment is an answer I'm going to post it here:

http://serverfault.com/questions/97282/restore-db2-database

That question poses a similar problem and contains the solution.

link|improve this answer
feedback
up vote -1 down vote

No way could you restore a database from a backed up image in another OS. The best way, as I am aware of, to do this is to create a barebone db in the target, set up federated server against the source db, create nicknames against tables then do a cursor/export load.

link|improve this answer
There is a way. It is not straightforward, but officially documented by IBM. See serverfault.com/questions/97282/restore-db2-database – Peter Schuetze Jan 8 '10 at 16:20
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.