Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Bangalore, India

    Unanswered: INSERT_UPDATE in LOAD

    DB2 9.7 FP 5 /AIX 6.1

    I know there is no option available in LOAD command as INSERT_UPDATE in IMPORT command however does someone know an alternative than can be used instead to make the process faster.

    One of our job which uses INSERT_UPDATE has been overunning.
    It does 98% inserts and very few updates in one run


  2. #2
    Join Date
    Jan 2009
    Zoetermeer, Holland
    Load into a temp-table followed by a MERGE
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Tags for this Thread

Posting Permissions

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