Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2007
    Posts
    4

    Unanswered: db2move error message

    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.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Apr 2007
    Posts
    4
    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 *_*

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  5. #5
    Join Date
    Apr 2007
    Posts
    4
    Thanks so much, Andy.

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

    Kay

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  7. #7
    Join Date
    Apr 2007
    Posts
    4
    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.

  8. #8
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Quote Originally Posted by ARWinner
    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.
    Aargh! I missed that "Windows" bullet.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •