Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: differance between import and load

    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................

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    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..
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Quote Originally Posted by ankur02018
    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................
    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!

  5. #5
    Join Date
    Jan 2003
    Posts
    1,605
    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.

  6. #6
    Join Date
    Jun 2007
    Posts
    197

    Smile

    Thanks for giving general informatiom on import and load

    if there is more than please continue

  7. #7
    Join Date
    Jan 2003
    Posts
    1,605
    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

  8. #8
    Join Date
    Jun 2007
    Posts
    197

    Smile

    Quote Originally Posted by grofaty
    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

Posting Permissions

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