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

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