Restoring the event monitor file

[rjha94]

$db2evmon -db DEV1926 -evm DB2DETAILDEADLO CK was showing data from all
the runs whereas i want the data just for a single run. To capture
fresh events, I deleted the old events file. caveat was, I deleted
this event file while DB2DETAILDEADLO CK was still active (state 1).

now when i Try to run the db2evmon command I get an error like

Cannot open Event Monitor file "/home/db2inst1/db2inst1/NODE0000/
SQL00005/db2event/db2detaildeadlo ck/00000000.evt."

I tried switching back and forth between state 0 and 1 but to no
avail. is there a way out? (apart from deleting the event and creating
it back again)

Thanks

- rajeev

[sadanjan]

Hi ,
Event monitor monitors deadlocks until configured max
files is full , db2evmon will show all the deadlocks since it is
configured to till current or max files have reached

Run " $ db2 " describe table syscat.eventmon itors " " to check to
how many max files your event monitor is configured to then drop
& recreate the event monitor to reflect your environment need

like for example
db2 " DROP EVENT MONITOR DB2DETAILDEADLO CK "
then recreate
db2 " create event monitor db2detaildeadlo ck for deadlocks with
details write to file 'db2detaildeadl ock' maxfiles 20 maxfilesize 512
buffersize 17 blocked append autostart "

regards
sadanjan

rjha94 wrote:

$db2evmon -db DEV1926 -evm DB2DETAILDEADLO CK was showing data from all
the runs whereas i want the data just for a single run. To capture
fresh events, I deleted the old events file. caveat was, I deleted
this event file while DB2DETAILDEADLO CK was still active (state 1).

now when i Try to run the db2evmon command I get an error like

Cannot open Event Monitor file "/home/db2inst1/db2inst1/NODE0000/
SQL00005/db2event/db2detaildeadlo ck/00000000.evt."

I tried switching back and forth between state 0 and 1 but to no
avail. is there a way out? (apart from deleting the event and creating
it back again)

Thanks

- rajeev