the strange message in db2diag.log

[jip102]

hi all!
2006-09-06-22.01.34.183570+540 I5679485A498 LEVEL: Error
PID : 655366 TID : 1 PROC : db2agent (AMISDB) 0
INSTANCE: amisinst NODE : 000 DB : AMISDB
APPHDL : 0-553 APPID: AC1F205E.J009.01B346130038
FUNCTION: DB2 UDB, database monitor, sqlmon_conn::cleanup_sqlmon_conn, probe:10
MESSAGE : Freeing leftover mon stmt. Stmt use count:
DATA #1 : Hexdump, 4 bytes
0x07800000001DB77C : 0000 0001

why this messages occur?

 

[sathyarams]

if your DIAGLEVEL setting is 4, just ignore the message, unless it is giving you a problem or performance impact.

db2 get dbm cfg

command will show your diaglevel

If your's is <4, then you may want to raise a PMR with IBM

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp