DB2性能问题

kindong

如果磁盘IO很忙的话。

oms400

估计你的buffpage是默认值,搞大点就能快很多,应用上索引估计也有问题
建议找个专业的db2 dba帮你分析一下

reallytrue

把程序或者SQL语句贴出来看一下，估计是只写磁盘而没有很好的利用CPU

jiangjinlu

类似的性能问题，如果你在上海，找我，我现场监控以下，保证给你解决问题！

华光骑士

You have noticed the procedure is bottleneck , contine to analyse may be find some cause .In general , to analyse sql statement block , you should find which sql is slow , maybe you lost some indexes on it .
Collect the sql block into a text file and use db2advis to assist the index creating .