Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Location
    Commonwealth, Quezon City
    Posts
    2

    Unanswered: DB2 error SQL3525N while import from 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.

    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.

    thanks in advance

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    with ixf the codepage has bee saved in export file - I presume this can be removed
    lobsinfile has to be specified if lobs file are being used
    see : IMPORT - IBM DB2 9.7 for Linux, UNIX, and Windows
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jan 2010
    Posts
    2
    At the time you import LOB data specifying the LOBSINFILE file type modifier, the server code page should be the same as the page of database code else, SQL3525N error is returned: the CODEPAGE option is incompatible with the LOBSINFILE option.
    So in order to solve out this very situation
    Use the DB2 load utility.
    If your IMPORT command is:
    import from myfile.ixf of ixf replace into mytable
    then you can try using the following command:
    load from myfile.ixf of ixf modified by codepage=1208 replace into mytable

    For more info about DB2 database error solution you can visit:
    DB2 Database Repair

  4. #4
    Join Date
    Jan 2010
    Location
    Commonwealth, Quezon City
    Posts
    2
    Thanks for all your replies

Posting Permissions

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