Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009

    Unanswered: DB2v9 slower than DBv8 while performing inserts

    I am facing a similar problem as the one mentioned in the below link:

    Can somebody plz help me in finding a solution in this regard?

  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    I'd suggest to start by reviewing the following article:
    Tips for improving INSERT performance in DB2 Universal Database

    It's a bit old but most of the info is still relevant. It has some general info on how to improve insert performance.

    If the table has indexes (especially a clustering index), then performing index reorg with the cleanup option prior to running inserts *might* help.

    If the problem only happened after v8-v9 upgrade, then testing with the latest (or more current) fixpak is not a bad idea.

Posting Permissions

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