微软2003服务器上安装了db2 数据库，但事件日志中报错，请大家帮忙分析

[lingerlove]

2009-02-18-09.50.06.640000 Instance:DB2 Node:000
PID:2964(db2fmp.exe) TID:3012 Appid:none
Health Monitor HealthIndicator::update Probe:500

ADM10501W 运行状况指示器
"已溢出的排序所占的百分比"（"db.spilled_sorts"）突破了在 "数据库" "DB2.WPSJCR6 "
上带有值 "33 %" 的 "30 %" 的 "上限"
警告阈值。计算：
"((delta(db.sort_overflows,10))/(delta(db.total_sorts,10)+1)*100);" = "(((1455
- 1453) / ((14420 - 14415) + 1)) * 100)" = "33 %"。历史（时间戳记、值和公式）："
(2009-02-18 09:44:06.656000, 13, (((1455 - 1453) / ((14420 - 14405) + 1)) *
100)), (2009-02-18 09:38:06.546000, 13, (((1455 - 1453) / ((14419 - 14404) +
1)) * 100)), (2009-02-18 09:32:06.906000, 13, (((1455 - 1453) / ((14419 -
14404) + 1)) * 100)), (2009-02-18 09:26:06.875000, 10, (((1455 - 1453) /
((14419 - 14399) + 1)) * 100)), (2009-02-18 09:20:06.921000, 10, (((1455 -
1453) / ((14419 - 14399) + 1)) * 100)), (2009-02-18 09:14:06.109000, 10,
(((1455 - 1453) / ((14419 - 14399) + 1)) * 100)), (2009-02-18 09:08:07.046000,
10, (((1455 - 1453) / ((14418 - 14398) + 1)) * 100)), (2009-02-18
09:02:06.421000, 10, (((1455 - 1453) / ((14418 - 14398) + 1)) * 100)),
(2009-02-18 08:56:06.250000, 10, (((1455 - 1453) / ((14417 - 14397) + 1)) *
100))"




2009-02-16-06.56.07.296000 Instance:DB2 Node:000
PID:2964(db2fmp.exe) TID:3012 Appid:none
Health Monitor HealthIndicator::update Probe:500

ADM10501W 运行状况指示器
"已溢出的排序所占的百分比"（"db.spilled_sorts"）突破了在 "数据库" "DB2.WPSJCR6 "
上带有值 "33 %" 的 "30 %" 的 "上限"
警告阈值。计算：
"((delta(db.sort_overflows,10))/(delta(db.total_sorts,10)+1)*100);" = "(((1405
- 1403) / ((13922 - 13917) + 1)) * 100)" = "33 %"。历史（时间戳记、值和公式）："
(2009-02-16 06:50:06.500000, 0, (((1403 - 1403) / ((13920 - 13917) + 1)) *
100)), (2009-02-16 06:44:06.578000, 0, (((1403 - 1403) / ((13920 - 13917) + 1))
* 100)), (2009-02-16 06:38:06.468000, 0, (((1403 - 1403) / ((13920 - 13917) +
1)) * 100)), (2009-02-16 06:32:06.734000, 0, (((1403 - 1403) / ((13919 - 13901)
+ 1)) * 100)), (2009-02-16 06:26:07.031000, 0, (((1403 - 1403) / ((13919 -
13901) + 1)) * 100)), (2009-02-16 06:20:29.687000, 0, (((1403 - 1403) / ((13919
- 13901) + 1)) * 100)), (2009-02-16 06:14:06.562000, 0, (((1403 - 1403) /
((13919 - 13901) + 1)) * 100)), (2009-02-16 06:08:06.718000, 0, (((1403 - 1403)
/ ((13919 - 13901) + 1)) * 100)), (2009-02-16 06:02:07.015000, 0, (((1403 -
1403) / ((13918 - 13900) + 1)) * 100))"

[Mr_Bean]

运行健康监视器看看有什么建议性更改

[chogo]

加大SORTHEAP和SHEAPTHRES的值看看：
-- SORTHEAP should be changed for individual database --
db2 -v update db cfg for DB_NAME using SORTHEAP 256
-- SHEAPTHRES is a database manager parameter --
db2 -v update dbm cfg using SHEAPTHRES 512
db2 -v terminate