为什么DB2在执行SQL查询时线程集中在两个CPU(共有8个CPU)?
SQL脚本:
select sum(DEB_CRE_LC)
from SRC.SRC_SAP_GL_LINE
where chrt_accts = 'OCOA'
and comp_code = '2003'
and fiscper = '2011006'
and wbs_elemt = 'EY308O10201000000'
------解决方案--------------------------------------------------------
设置一下,启用db2的分区内并行性能够更好地使用硬件资源