Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: MDC table insert performance

    Db2 V 9.7 Fix 8

    Aix

    MDC table having 2.6 million records, mostly insert happens Nothing much of delete and update.

    Enabled BLOCKINSERT for locksize no improvement

    Insert job is taking around 7 hrs,

    Statis is 4 days old, Reorgchk says reorg not required.

    No table overflows etc

    Db2_alternative_page_clean is enabled for Num I/O cleaners

    Any other suggestion to improve the insert MDC table performance.

    Regds
    Paul

  2. #2
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    Try using registry variable DB2_TRUST_MDC_BLOCK_FULL_HINT=ON. For more details refer to http://www-01.ibm.com/support/knowle.../r0005665.html

  3. #3
    Join Date
    Oct 2007
    Posts
    246
    Tried that earlier itself, no improvement,

    do it needs instance recycle to take this register variable to effect.

    Regds
    Paul

  4. #4
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    All registry variable updates require instance restart for the changes to be effective. The following statement is from IBM Knowledge Center.

    "You must set values for registry variables that you want to update before you execute the db2start command"

Posting Permissions

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