var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MDC table insert performance
Db2 V 9.7 Fix 8
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.
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
Tried that earlier itself, no improvement,
do it needs instance recycle to take this register variable to effect.
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"