I want to copy data from our production database to the development database. I want to move only the data. I do not need the table structure, constrains or anything else.

I think I can use the db2move command to export out all the data like the following:

db2move dbname export -tc schema1


When I load the data into our development database, will it recreate the tables? My problem is that I do not want to recreate the structure. I want to make sure that I am copying over only the data.

Is db2move the best utility to move the data between two databases without making any structure changes to the target database?

DB2 & UDB email list listserv db2-l LazyDBA home page