当前位置: 传客网 > DB2 performance tuning summary

DB2 performance tuning summary

2016-10-17 作者:kangdong.yang

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.


相关推荐

返回
顶部