How do I do a cross-platform backup/restore of a DB2 database?
Posted
by Pridkett
on Server Fault
See other posts from Server Fault
or by Pridkett
Published on 2009-12-17T19:33:07Z
Indexed on
2010/04/13
20:33 UTC
Read the original article
Hit count: 353
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?
© Server Fault or respective owner