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

Filed under:
|
|

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

Related posts about db2

Related posts about backup