1

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?

3

2 Answers 2

0

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

Restore DB2 database

That question poses a similar problem and contains the solution.

-1

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.

1

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .