db2move from DB2 AIX to Windows

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • princesmay
    New Member
    • Dec 2009
    • 2

    db2move from DB2 AIX to Windows

    Hello All,

    Im trying to import all the IXF and MSG files that i have exported from AIX db2, however this error occured while importing to Windows in every tables. Hope you can help me. thanks in advance

    SQL3104N The Export utility is beginning to export data to file "tab436.ixf ".

    SQL3105N The Export utility has finished exporting "20421" rows.

    SQL3150N The H record in the PC/IXF file has product "DB2 02.00", date
    "20091223", and time "144728".

    SQL3050W Conversions on the data will be made between the IXF file code page
    "819" and the application code page "1252".

    SQL3153N The T record in the PC/IXF file has name "tab436.ixf ", qualifier "",
    and source " ".

    SQL3109N The utility is beginning to load data from file "tab436.ixf ".

    SQL3525N The "CODEPAGE" option is incompatible with the "LOBSINFILE " option.

    SQL3110N The utility has completed processing. "0" rows were read from the
    input file.
  • Parnamwulan
    New Member
    • Apr 2008
    • 16

    #2
    Hello Princesmay,

    you need to have the same codepage on both dbs

    you can change the codepage by:

    db2set db2codepage=

    or you can specify MODIFIED BY CODEPAGE option ... but it will not work for .ixf files as they have inside the source codepage

    Comment

    Working...