By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

Restoring the event monitor file

P: n/a
$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
Share this Question
Share on Google+
1 Reply


P: n/a
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.