Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2008
    Posts
    21

    Unanswered: db2move for Windows & AIX

    Hi,

    I am using the db2move to sxport sample schema from windows platform (db2move sample export) and the exported files copied into aix platform and db2move sample import (db2move sample import).

    While importing the below given error is accorred.

    $ db2move sample import -l /home/db2inst1/samp

    ***** DB2MOVE *****

    Action: IMPORT

    Start time: Thu Apr 24 17:24:16 2008


    Connecting to database SAMPLE ... successful! Server: DB2 Common Server V8.2.9

    * IMPORT: table "SYSTOOLS"."STMG_DBSIZE_INFO"
    ***ERROR -3525. Check message file tab1.msg!
    *** SQLCODE: -3525 - SQLSTATE:
    *** SQL3525N The "CODEPAGE" option is incompatible with the "LOBSINFILE" option.

    * IMPORT: table "SYSTOOLS"."HMON_ATM_INFO"
    ***ERROR -3525. Check message file tab2.msg!
    *** SQLCODE: -3525 - SQLSTATE:
    *** SQL3525N The "CODEPAGE" option is incompatible with the "LOBSINFILE" option.

    * IMPORT: table "SYSTOOLS"."POLICY"
    ***ERROR -3525. Check message file tab3.msg!
    *** SQLCODE: -3525 - SQLSTATE:
    *** SQL3525N The "CODEPAGE" option is incompatible with the "LOBSINFILE" option.

    * IMPORT: table "SYSTOOLS"."HMON_COLLECTION"
    ***ERROR -3525. Check message file tab4.msg!
    *** SQLCODE: -3525 - SQLSTATE:
    *** SQL3525N The "CODEPAGE" option is incompatible with the "LOBSINFILE" option.


    Disconnecting from database ... successful!

    End time: Thu Apr 24 17:24:18 2008


    Please help me.

    Thanks,

    Mohan Reddy

  2. #2
    Join Date
    Oct 2004
    Posts
    268
    Take a look at here se if it helps..............

    http://www-1.ibm.com/support/docview...id=swg21220689

  3. #3
    Join Date
    Jan 2008
    Posts
    45
    Codepage mismatch occurs when you try to load windows generated files onto AIX..You can do two things

    1)Go to AIX box and run export DB2CODEPAGE=1252

    2)you can run the db2move from your windows client through commandcenter
    if your db on AIX is cataloged on the windows client

Posting Permissions

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