hi
there is one big differance between db2 import and load

db2move databasename import - u username -p password

db2move databasename load - u username -p password


1-In import values overwrites but in load values appends

and more are................

what is the question ?
there are many differences between import and load
1-In import values overwrites but in load values appends
there are options to specify if insert/replace... into table should be used..

Load writes directly to the data pages while import sends regular INSERT statements. The former is usually faster, the latter has the advantage that UDFs or triggers will be executed, for example.

Don't know how db2move is working by default, but you can specify how import is working by using switches:
http://publib.boulder.ibm.com/infoce...e/r0002079.htm
You can replace or append data.

This is not the difference between load and import!

General info about load vs. import:
There is also performance and locking difference. Load usually loads 100-times faster or more. Load doesn't use transaction logic. I only use load if I am 100% sure that I am the only user on the database - for example data warehouse table. I use import when I am not the only one on database or there are some triggers on tables or when I would like inserted data to be executed just like usually data through user application.

Using load in multi-user environment using the same tables as you load into, can be dangerous, because table lock or even tablespace lock can be applied.

Thanks for giving general informatiom on import and load

if there is more than please continue

Hi,
you can also try searching the web by Google. I found out this page:
http://www.thescripts.com/forum/thread185636.html
Hope this helps,
Grofaty

thnks my dear