DB2 performance tuning summary

db2 tuning performance it

1. use asynchronous IO, raw device and CIO(concurrent IO)

2. 5 - 10 disks per CPU for common workload. At least 20 disks per CPU for high IO OLTP workload. Log and tablespace should have their own special disk.There should be some disks for log,table and index. 

3. Right database parameter config.

4. create suitable index for table. use Index advisor tool

5. Make sure the application hold locks as short as possible.

6. use sql efficiently.

7. analyse sql executing plan.

8. datbase physical and logic design.

9. runstat and reorg.

10. know the optimizer.

相关推荐

你的评论

就没有什么想说的吗?

最新博客

关于我们 免责声明 移动版

©2017传客网    琼ICP备15003173号-2    

本站部分文章来源于互联网,版权归属于原作者。
本站所有转载文章言论不代表本站观点,如是侵犯了原作者的权利请发邮件联系站长(weishubao@126.com),我们收到后立即删除。
站内所有资源仅供学习与参考,请勿用于商业用途,否则产生的一切后果将由您自己承担!

X