Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2014

    Unanswered: DB2 Bulk update online database

    Hi All,

    I want to update an online table with 2 million records every hour. What is the best possible way to do it without impacting performance and avoiding any locking issues.

    Can the above be done if we put 2 failover databases and update the records in one of the databases while taking the other offline? When one of the databases in this set up is taken offline whether the other one becomes primary automatically?


  2. #2
    Join Date
    Dec 2007
    Richmond, VA
    Provided Answers: 5
    I think you need a better explanation of what you are wanting to do. Give us an example of your table structure and what updates you are performing.

Posting Permissions

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