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

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

Check that db2move.lst is readable and not damaged.