467,170 Members | 1,165 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,170 developers. It's quick & easy.

Restoring the event monitor file

$db2evmon -db DEV1926 -evm DB2DETAILDEADLOCK 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 DB2DETAILDEADLOCK 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/db2detaildeadlock/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

Aug 2 '07 #1
  • viewed: 5512
Share:
1 Reply
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.eventmonitors " " 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 DB2DETAILDEADLOCK "
then recreate
db2 " create event monitor db2detaildeadlock for deadlocks with
details write to file 'db2detaildeadlock' maxfiles 20 maxfilesize 512
buffersize 17 blocked append autostart "

regards
sadanjan

rjha94 wrote:
$db2evmon -db DEV1926 -evm DB2DETAILDEADLOCK 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 DB2DETAILDEADLOCK 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/db2detaildeadlock/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
Aug 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jian Chen | last post: by
1 post views Thread by Robbert van Geldrop | last post: by
4 posts views Thread by Raj | last post: by
1 post views Thread by Jo | last post: by
1 post views Thread by vijay.db@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.