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
DB2 & UDB email list listserv db2-l LazyDBA home page