互联网服务数据库
health monitor 一直出ADM10500E的错误信息
用的db2 V9.5版本，db_heap设置的automatic，在db2diag.log中经报下面这种错误
2010-08-03-15.13.08.248039+540 E1224160A1342 LEVEL: Error
PID : 20746 TID : 2199197206864PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10500E Health indicator "繝・・繧ｿ繝吶・繧ｹ繝ｻ繝偵・繝嶺ｽｿ逕ｨ邇・
("db.db_heap_util") breached the "荳企剞" alarm threshold of "95 %"
with value "125 %" on "繝・・繧ｿ繝吶・繧ｹ" "db2inst1.LISMC ".
Calculation: "((db.db_heap_cur_size/db.db_heap_max_size)*100);" =
"((42598400 / 34078720) * 100)" = "125 %". History (Timestamp, Value,
Formula): " (2010-08-03 15:08:08.180517, 65, ((22282240 / 34078720) *
100)), (2010-08-03 15:03:08.081200, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:58:08.914340, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:53:08.740983, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:48:08.651381, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:43:08.487912, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:38:08.219311, 65, ((22216704 / 34078720) *
100)), (2010-08-03 14:33:08.117021, 65, ((22216704 / 34078720) *
100)), (2010-08-03 14:28:08.967109, 65, ((22216704 / 34078720) *
100))"
该如何解决此类问题。
2010-08-03-15.13.08.248039+540 E1224160A1342 LEVEL: Error
PID : 20746 TID : 2199197206864PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10500E Health indicator "繝・・繧ｿ繝吶・繧ｹ繝ｻ繝偵・繝嶺ｽｿ逕ｨ邇・
("db.db_heap_util") breached the "荳企剞" alarm threshold of "95 %"
with value "125 %" on "繝・・繧ｿ繝吶・繧ｹ" "db2inst1.LISMC ".
Calculation: "((db.db_heap_cur_size/db.db_heap_max_size)*100);" =
"((42598400 / 34078720) * 100)" = "125 %". History (Timestamp, Value,
Formula): " (2010-08-03 15:08:08.180517, 65, ((22282240 / 34078720) *
100)), (2010-08-03 15:03:08.081200, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:58:08.914340, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:53:08.740983, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:48:08.651381, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:43:08.487912, 65, ((22282240 / 34078720) *
100)), (2010-08-03 14:38:08.219311, 65, ((22216704 / 34078720) *
100)), (2010-08-03 14:33:08.117021, 65, ((22216704 / 34078720) *
100)), (2010-08-03 14:28:08.967109, 65, ((22216704 / 34078720) *
100))"
该如何解决此类问题。
8同行回答
database heap include shits like memory allocation tree, audit buffer, table control blocks, directo ...wangzhonnew 发表于 2011-1-13 03:35
shits ;Pdatabase heap include shits like memory allocation tree, audit buffer, table control blocks, directo ...
wangzhonnew 发表于 2011-1-13 03:35
shits ;P收起
浏览1936
database heap include shits like memory allocation tree, audit buffer, table control blocks, directories (for compressed table), etc...
usually the size for the heap is not volatile unless you have huge amount of temporary tables (like thousands or even more) goes create/drop/create/dropsimultaneously...
125% means it's overflowed into overflow memory when the max is reached.. did you restart database after set the memory size to automatic? :)收起
usually the size for the heap is not volatile unless you have huge amount of temporary tables (like thousands or even more) goes create/drop/create/dropsimultaneously...
125% means it's overflowed into overflow memory when the max is reached.. did you restart database after set the memory size to automatic? :)收起
浏览1939
我的理解：这个错误是由于DBHEAP不够的缘故，但是已经设成自动调整的。为什么还要出错。
二楼：DBHEAP中并不包含CATALOG的HEAP，设置这个有关联吗？
三楼：MON_HEAP_SZ是关于health monitor的heap大小，跟这个错误的DBHEAP会有什么关联收起
二楼：DBHEAP中并不包含CATALOG的HEAP，设置这个有关联吗？
三楼：MON_HEAP_SZ是关于health monitor的heap大小，跟这个错误的DBHEAP会有什么关联收起
浏览1953
Not a big problem.
AUTOMATIC means soft limit, that is, the database heap can increase as needed until either the database_memory limit is reached, or the instance_memory limit is reached.
It does not mean STMM's AUTOMATIC Tuning.
As of V9.5, if you set it to concrete value, it's hard limit.收起
AUTOMATIC means soft limit, that is, the database heap can increase as needed until either the database_memory limit is reached, or the instance_memory limit is reached.
It does not mean STMM's AUTOMATIC Tuning.
As of V9.5, if you set it to concrete value, it's hard limit.收起
浏览2024