Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    5

    Unanswered: update statement for 500000 rows

    Hi
    I am new to DB2.
    I need to do an update for 500000 rows in a table. Can somebody help me with the query?
    Something like bulk update which can be faster...

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    How about the "good old" 80/20 rule? Those 500,000 rows, are they more or less than 20% of the totoal number of rows in the table?
    If more
    THEN EXPORT in a seq.file, update the records in the seq.file and reload the file into the table (db must be quiesced)
    ELSE just code and execute the UPDATE query(s). See if you can divide the set into logical chunks and include that logic in you where clause. This will take the pressure off the log bottleneck.

Posting Permissions

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