Hi,

This is my first time to remove event monitor log files in our production server.
In the db2inst1.nfy, it always shows the following message

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

Our current number of output files for event monitor, db2detaildeadlock, is reach 20 and the size of each file is 2M.

Obviously, I need to remove those output files under db2event/db2detaildeadlock folder because the number of files is reach 20, maximum number by default.

However, what's the process of removing?

Should I do the removing work by following process? (Method A)
1. db2 connect to db_name.
2. db2 "set event monitor DB2DETAILDEADLOCK state 0"
3. Delete all 20 output files in db2event/db2detaildeadlock folder
4. db2"set event monitor DB2DETAILDEADLOCK state 1"
5. db2 connect reset

Or, I just delete all 20 output files from the folder, db2detaildeadlock, directly? (Method B)

Or, I can do it by another way? (Method C)

Which one I should do? A, B, or C?

Since it is for our production database, I need to double check for it.

Thanks,
zhif

Event monitor is already deactivated so you can remove all .evt files and db2event.ctl and then restart the monitor.

Hi Bella,

So, the exact process is,
1. Remove all files in 'db2detaildeadlock' folder
2. db2 connect to db_name
3. db2"set event monitor DB2DETAILDEADLOCK state 1"
4. db2 connect reset

Is it correct?

Thanks,
zhif

Sounds goods. Use db2evmon to save deadlock info prior to removing the files, if needed. You can also drop this default event monitor and create your own.

Thank you. Bella