Hi Kevin
At V8 you will always see Health Monitor messages in the db2diag.log, even
with the health_mon dbm cfg switch off; I raised a PMR for this quite some
time ago and was advised you can safely ignore the warning messages. In your
case below I reckon the severe ones as well, if you know why libraries are
missing and are happy with that. As to why these messages appear, that's a
different story - sorry, it was a client site a couple of years back and
memory is hazy but I think there was a distinction between the hm process
itself which is always active and the actual monitoring itself which you can
disable; or something like that.
Hope this helps,
Alex Levy
Sustainable Software Ltd.
-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x65826937.[Email address protected]
Sent: 27 December 2006 17:49
To: LazyDBA Discussion
Subject: RE: Health Monitor trys to restart even when switch is off
Hey Kevin,
Will the following code work for you (run each statement separately, then
bounce the database)?
update dbm configuration using dft_mon_sort off
update dbm configuration using dft_mon_lock off
update dbm configuration using dft_mon_table off
update dbm configuration using dft_mon_bufpool off
update dbm configuration using dft_mon_uow off
update dbm configuration using dft_mon_stmt off
update dbm configuration using dft_mon_timestamp off
update monitor switches using statement off
Please take a few minutes to provide feedback on the quality of service you
received. The Department of Education values your feedback as a customer.
Commissioner John L. Winn is committed to continuously assessing and
improving the level and quality of services provided to you by Department
staff. Simply use the link below. Thank you in advance for completing the
survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Kevin Knaus [mailto:db2udbdba-ezmlmshield-x30485619.[Email address
protected]
Sent: Wednesday, December 27, 2006 12:24 PM
To: LazyDBA Discussion
Subject: Health Monitor trys to restart even when switch is off
We are seeing a cyclic (repeating) error concerning the Health monitor
trying to start but not succeeding. The health monitor switch for the
affected database is off. (we want it off)
why does it attempt to restart? This message succeeds in restarting but
later we get errors. I don't want it restarting. Is it related to the
control center gui doing something with java in the background?
2006-12-27-10.51.19.985680-360 I26565675G280 LEVEL: Warning
PID : 4863 TID : 3085866688 PROC : db2sysc
INSTANCE: db2inst4 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleRunSysCtlr, probe:63
MESSAGE : Health Monitor Process restarted.
We also see errors a bit later when certain shared libraries are not found
which seem to be related to health monitor. See...
2006-12-27-10.51.20.142076-360 I26567215G392 LEVEL: Severe
PID : 28363 TID : 3066939712 PROC : db2hmon
INSTANCE: db2inst4 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpThreadInit, probe:30
MESSAGE : Failure during heath monitor thread initialization
DATA #1 : Hexdump, 4 bytes
0xBFFFF76C : 9B00 0F87
And in case someone asks, here is the level of the db, and it is running on
an IBM Linux blade (2 cpu) Os level is 2.6 of Linux.
[[Email Address Removed] db2dump]$ db2level
DB21085I Instance "db2inst4" uses "32" bits and DB2 code release "SQL08024"
with level identifier "03050106".
Informational tokens are "DB2 v8.1.2.104", "s060120", "MI00152", and FixPak
"11".
Product is installed at "/opt/IBM/db2/V8.1".
Thank you,
Kevin Knaus
CMS Direct
UDB DBA
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------
Scanned by 186k-NetCleanse, spam and virus protection
DB2 & UDB email list listserv db2-l LazyDBA home page