Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    19

    Question Unanswered: db2 import command is not working giving error

    hi everyone


    i m using two different O.S ....my database is in Linux O.S .i want to export the dataasbe from linux environment to windows .

    since i came to know two differrnt O.S specially Linux and wonsows I cannnot use Db2 Backup and Restore command ...


    SO in place of that i m trying to use db2move coammnd with import and export

    db2move export sample
    this command is working i got in IXF format

    then i m trying to import this IXF file .
    using

    db2move SAMPLE import


    table stricture i got but i m getting error

    no .of rows read:7
    no.of rows rejected:7


    SQL3550W The field value in row "1" and column "1" is not NULL, but the
    target column has been defined as GENERATED ALWAYS.

    SQL3550W The field value in row "2" and column "1" is not NULL, but the
    target column has been defined as GENERATED ALWAYS.

    SQL3550W The field value in row "3" and column "1" is not NULL, but the
    target column has been defined as GENERATED ALWAYS.

    SQL3550W The field value in row "4" and column "1" is not NULL, but the
    target column has been defined as GENERATED ALWAYS.

    SQL3550W The field value in row "5" and column "1" is not NULL, but the
    target column has been defined as GENERATED ALWAYS.

    SQL3550W The field value in row "6" and column "1" is not NULL, but the
    target column has been defined as GENERATED ALWAYS.

    SQL3550W The field value in row "7" and column "1" is not NULL, but the
    target column has been defined as GENERATED ALWAYS.

    SQL3110N The utility has completed processing. "7" rows were read from the
    input file.

    SQL3221W ...Begin COMMIT WORK. Input Record Count = "7".

    SQL3222W ...COMMIT of any database changes was successful.

    SQL3149N "7" rows were processed from the input file. "0" rows were
    successfully inserted into the table. "7" rows were rejected.



    another thing if i m using this commadn
    db2move SAMPLE import -io INSERT_UPDATE

    i m gettting error

    * IMPORT: table "ashrash "."ADMIN_MASTER"
    ***ERROR -3203. Check message file tab113.msg!
    *** SQLCODE: -3203 - SQLSTATE:
    *** SQL3203N The INSERT_UPDATE option is not permitted for the specified targe
    t because it has no primary key or all columns are
    in the primary key.


    please help me out whats is the problem ,how can i resolve this

    thank you

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    you can't move tables with "db2move import" command if generated always columns exists on table.

    Use export/import tools, don't export generated columns.
    Regards

Posting Permissions

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