Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: What is the best options to load 100.000.000 rows between load insert or replace?

    Hello colleagues,
    I need to load 100.000.000 rows in table partitioned table using load, i will be use insert or replace?

    Best regards.
    DBA DB2 for LUW

  2. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    That depends on whether the table has existing data and whether you want to keep that existing data. As per the manual....

    INSERT Adds the loaded data to the table without changing the existing table data.

    REPLACE Deletes all data from the table, and inserts the new data. The table definition and index definitions are not changed.

Posting Permissions

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