Prev: Error activating a database/cannot allocate agent
Next: how to change user password
From: rjha94 on 2 Aug 2007 04:48
$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

From: sadanjan on 5 Aug 2007 00:56
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

 | 
Pages: 1
Prev: Error activating a database/cannot allocate agent
Next: how to change user password