How do I do a cross-platform backup/restore of a DB2 database?

Question

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?

duplicate of http://serverfault.com/questions/97282/restore-db2-database — Peter Schuetze, Dec 29 '09 at 19:24
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

score 0 · Accepted Answer · edited Apr 13 '17 at 12:14

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.

edited Apr 13 '17 at 12:14

Community

1

answered Apr 13 '10 at 20:28

Pridkett

176
2
8

score -1 · Answer 2 · answered Dec 30 '09 at 06:15

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

answered Dec 30 '09 at 06:15

Arun Srini

43
6

There is a way. It is not straightforward, but officially documented by IBM. See http://serverfault.com/questions/97282/restore-db2-database – Peter Schuetze Jan 08 '10 at 16:20

How do I do a cross-platform backup/restore of a DB2 database?

2 Answers2