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

    Unanswered: DB2v9 slower than DBv8 while performing inserts

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

    http://www.dbforums.com/db2/1620263-...b2-v9-1-a.html

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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    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
  •