Hello

I have a problem migrating db2 database from Windows platform to Linux Redhat.

I use db2move to export database from Windows and then use db2look command to generate DDL

statement.

After that I transfer .ixf files, db2move.lst, and db2look.sql to Linux.

In Linux platform, I type the command as the following
db2 create dbname
db2 -tvf db2look.sql
db2move dbname load

I got error message from the last command as show below


Application code page not determined, using ANSI codepage 1208


Error opening report file. Terminating...


**Error occured while opening a file.


on Windows I use DB2 Version 9.1.0.365
on Linux I use DB2 Version 9.1.0

Do you have any suggestion to fix this problem or any other technique to migrate DB2 database from Windows to Linux.

Thanks.

Why so complicated? Take a backup on Windows and restore it on Linux. The only restriction regarding portability of backup images in V9 is that source and target systems must both be little endian or both big endian.

Thank you so much for your advice.

I thought the only way to migrate database across platform was db2move.

Today I try backup and restore as you suggested.

When I restore to LINUX I got error message as below

SQL2570N An attemp to restore on target OS "Linux-IA32" from a backup created on source OS "NT-32" failed due to the incompatibility of operating systems or an incorrect specification of the restore command. Reason-code: "1".

Do you have any suggest to fix this problem?

Thanks again *_*

You cannot backup on Windows and restore to anything else. Look at the DB2 documentation:

http://publib.boulder.ibm.com/infoce...c/c0005960.htm

It is only the Linux/Unix that can be done that way.

Andy

Thanks so much, Andy.

So the only way to migrate database from Windows to Linux is db2move, right?

Kay

Using db2move is probably the preferred way. But there are other ways. One way would be to use DB2 Federation and LOAD from cursor. It all depends on the resources you have, how many tables, etc.

Andy

Thank you so much Stolze and Andy

Now I'm back to use db2move command.
I just found that the reason of those error message it because of the user db2admin is no permission to write file.

Aargh! I missed that "Windows" bullet.