共同进步
作者共同进步·2013-11-27 10:50
数据库架构师·中国金融电子化公司

加速MDC表的加载速度

字数 936阅读 427评论 0赞 0

db2set DB2_TRUST_MDC_BLOCK_FULL_HINT=true

 

- the insert code to trust the FULL bits in the block indexes

  even though this is just a hint. So only the first pass of

  the block index will be done. The first pass will only

  visit blocks which do not have the FULL bit set.

  If the visited blocks are found to be full, the FULL bit

  will be set in the block index. The second pass of the

  block index, which visits blocks even if the FULL bit is

  set, and which clears the FULL bit when space is found,

  will not be done.

 

- This will speed up the insert.

 

- The side affect of this registry variable is that until an

  entire block is deleted, any space freed by deletes within

  those blocks will not be reused.

alter table tablename locksize blockinsert

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关文章

相关问题

相关资料

X社区推广