Results 1 to 3 of 3

Thread: DB2MOVE problem

  1. #1
    Join Date
    Sep 2005
    Posts
    3

    Unanswered: DB2MOVE problem

    Hello,

    I used db2move command to export a db2 7.1 db on solaris. The command is:

    db2move GENEL export

    I created a database on db2 8.2 on windows xp professional. I the issued the command;

    db2move GENEL import

    The response i get is:

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

    What's going wrong? I did not supply any options. Any suggestions?

  2. #2
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Quote Originally Posted by shendric
    Hello,

    I used db2move command to export a db2 7.1 db on solaris. The command is:

    db2move GENEL export

    I created a database on db2 8.2 on windows xp professional. I the issued the command;

    db2move GENEL import

    The response i get is:

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

    What's going wrong? I did not supply any options. Any suggestions?
    At your db2cmd prompt, type the following for an explanation.

    "? SQL3505N"

    HTH

  3. #3
    Join Date
    Jan 2004
    Posts
    49
    Quote Originally Posted by shendric
    Hello,

    I used db2move command to export a db2 7.1 db on solaris. The command is:

    db2move GENEL export

    I created a database on db2 8.2 on windows xp professional. I the issued the command;

    db2move GENEL import

    The response i get is:

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

    What's going wrong? I did not supply any options. Any suggestions?
    use the following command while LOBs are present,

    Export:
    db2 "export to <<fille name>> of <<file type>> lobs to <<lob path>> select * from <<table name>> "

    Import:
    db2 "import from <<file name>> of <<file type>> lobs from <<lob path>> ........."
    Last edited by bala_e; 12-12-05 at 08:10.

Posting Permissions

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