Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|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

2 Answers 2

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.

share|improve this answer

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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