Hi,

I am trying to transfer data from one database to another database in personal edition of DB2 using db2move.

When I do the import using db2move tables that has auto increment columns are not populated.

If this is not possible how can I do cross platform data transer.

Your suggestions required.

Thanks.

You will have to manually import those tables with columns that are "always" generated (instead of generated by default). You can use the IXF files created by the db2move export, but create individual import or load statements that use the MODIFIED BY IDENTITYOVERRIDE parameter to allow the load/import to work properly.

I tried to load data to os/400 database using the following command.

db2 => load from 'c:/data/tab77.ixf' OF IXF MODIFIED BY IDENTITYOVERRIDE insert into MCD_DB.EMPLOYEE

I get the below given error.

SQL1325N The remote database environment does not support the command or one
of the command options.

Remote load to OS/400, SO/390 and z/OS are not supported. You have to use import with option INSERT only. IBM is still researching on this issue.

THANKS FOR THAT.

But with IMPORT can I transfer identity columns also? All my tables has Identity columns as primary key. I want to transfer my local database to os/400. Is there a way out.


Thanks