請教：數(shù)據(jù)庫出現(xiàn)如下問題，應(yīng)如何解決？

johnswood

在db2inst1.nfy文件中不停的出現(xiàn)如下報警，文件尺寸增長很快，怎么才能消除如下的報警信息。


2005-06-23-16.14.48.491562   Instance:db2inst1   Node:000
PID:13728(db2agent (TOOLSDB))   TID:8192   Appid:*LOCAL.db2inst1.023173081448
database monitor  sqm.evmgr::log_ev_err Probe:2   Database:TOOLSDB

ADM2001W  The Event Monitor "DB2DETAILDEADLOCK" was deactivated because the
MAXFILES and MAXFILESIZE CREATE EVENT MONITOR parameters' limits have been
reached.

mymm

你的死鎖監(jiān)視器有用嗎？

沒用把它關(guān)掉吧!這樣比較好!

1. db2 set event monitor db2detaildeadlock state 0
   
2. db2 drop event monitor db2detaildeadlock

復(fù)制代碼

有用的話再重建，并指定maxfile和maxfilesize大一些。

CREATE EVENT MONITOR db2detaildeadlock FOR DEADLOCKS WITH DETAILS WRITE TO FILE '/YOURFILE'  MAXFILES 10 MAXFILESIZE NONE  AUTOSTART ;