數(shù)據(jù)庫怎么調(diào)整SHEAPTHRES大小

我老婆黑社會

ADM10500E  Health indicator "ercentage of Sorts That Overflowed"
("db.spilled_sorts" breached the "upper" alarm threshold of "50 %" with value
"51 %" on "database" "tpuser1.TPUSER  ".  Calculation:
"((delta(db.sort_overflows,10))/(delta(db.total_sorts,10)+1)*100);" = "(((11922
- 11820) / ((90675 - 90476) + 1)) * 100)" = "51 %".  History (Timestamp, Value,
Formula): " (2007-12-04 01:26:15.207831, 39, (((11922 - 11819) / ((90675 -
90409) + 1)) * 100)), (2007-12-04 01:20:15.989947, 38, (((11922 - 11819) /
((90675 - 90404) + 1)) * 100)), (2007-12-04 01:14:15.905483, 40, (((11918 -
11819) / ((90651 - 90404) + 1)) * 100)), (2007-12-04 01:08:15.727863, 39,
(((11914 - 11813) / ((90627 - 90366) + 1)) * 100)), (2007-12-04 01:02:15.553533,
39, (((11914 - 11813) / ((90627 - 90366) + 1)) * 100)), (2007-12-04
00:56:15.362354, 39, (((11914 - 11813) / ((90627 - 90366) + 1)) * 100)),
(2007-12-04 00:50:15.176794, 36, (((11914 - 11807) / ((90627 - 90330) + 1)) *
100)), (2007-12-04 00:44:16.025351, 36, (((11914 - 11807) / ((90627 - 90330) +
1)) * 100)), (2007-12-04 00:38:15.842139, 11, (((11824 - 11805) / ((90485 -
9031 + 1)) * 100))"

數(shù)據(jù)庫報上面的ＡＬＥＲＴ，查了一下需要調(diào)整SHEAPTHRES，但是不知道調(diào)到多少合適，請指點一下

coolalibaba

Configuring SHEAPTHRES:

    * In general SHEAPTHRES should be set to a multiple of SORTHEAP
    * A general rule of thumb is to set SHEAPTHRES to at least 10 * SORTHEAP.
    * For index creation with INTRA_PARALLEL ON, make sure SHEAPTHRES >= d * SORTHEAP, where d is the SMP degree.
    * For LOAD, all index key sorting takes place simultaneously in the private memory space of one process: db2lrid in SMP, db2lfrm0 in serial. Make sure SHEAPTHRES >= n * SORTHEAP, where n is the number of indexes on the table being loaded. Also keep in mind that on AIX, there is approximately a max of 250MB of private virtual memory for index key sorting in LOAD (this is a memory bottleneck).

我老婆黑社會

非常感謝!

weizeyan

db2 update db cfg using SHEAPTHRES <size>