Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    23

    Unanswered: db2move <database> LOAD error

    I'm using DB2 V9.1 with Unix. Trying to migrate a particular database, copying data and lobs from version 8.2 to version 9.1. Here is what I did:

    Export the data from source:
    db2move <database> export

    Which includes count, word count, and byte count:
    ls -l | wc 99 884 6411

    Export the lobs to target:
    db2move <database> export –l /db2_data/data/
    ls -l | wc 99 884 6723

    This includes an extra ddl and no system.msg file on target. That is why the count is the same. Not sure if the system.msg file matters or not.


    Now I'm trying to load the data and lobs into the tables:
    db2move <database> LOAD –lo INSERT –l /db2_data/data/

    This is the error message I get:

    Application code page not determined, using ANSI codepage 819


    Error opening report file. Terminating ...

    **Error occured while opening a file.


    Could someone help me out or have any ideas what could be causing this error?

    Thank you.


    CC

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I do not know the solution to your particular problem, but if you are migrating the entire database from the same OS that you are migrating to, why not just backup on 8.2 and restore to 9.1?

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check that db2move.lst is readable and not damaged.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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