473,398 Members | 2,125 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

Event monitor issue..

Hi group,

Have a problem with event monitor so my db2diag.log is getting filled
like any thing..

Running DB2 V8.1 Fixpack 6 in AIX server.

Created a event monitor and redirecting it's output to a file..getting
error like

2007-02-20-00.06.52.470942 Instance:***** Node:000
PID:1229054(db2agent (*****) 0) TID:1 Appid:*LOCAL.*****.
0209B0000649
database monitor sqm___start_evmon Probe:32 Database:*****

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x840D000C".

PID:1229054 TID:1 Node:000 Title: event monitor name
0x20066B38 : 4445 4144 4C4F 434B 5F45 5654 53 DEADLOCK_EVTS

PID:1229054 TID:1 Node:000 Title: event monitor target
0x20066B60 : 2F68 6F6D 652F 6475 6D66 6370 312F 6D66 /home/dum/mf
0x20066B70 : 6330 3170 312F 6475 6D66 6370 312F 4E4F c/dum/NO
0x20066B80 : 4445 3030 3030 2F53 514C 3030 3030 312F DE0000/
SQL00001/
0x20066B90 : 6462 3265 7665 6E74 2F44 4C4F 434B 53 db2event/
DLOCKS

2007-02-20-00.06.52.500447 Instance:dumfcp1 Node:000
PID:1229054(db2agent (*****) 0) TID:1 Appid:*LOCAL.*****.
0209B0000649
database monitor sqm___evmgr::log_ev_err Probe:1 Database:*****

DiagData
0x2FF1B410 : 0x840D000C ....

As I got repeated error like this, I turned off the event monitor, but
still my db2diag.log is getting filled with the above error message?

Queries:

Is it problem with starting the event monitor?
problem with redirecting the data to file?
some other issue?

Thanks in advance..
vj_dba

Feb 20 '07 #1
1 3316
prm
Vijay,

There is an event monitor that monitors deadlocks that is on by default.
There is a directory where the deadlock event monitor files are written, 20
I think. Find that directory and delete or move all of the files but the
latest one. Alternately, you could drop then recreate that monitor stating
a larger number of files or you may decide you do not need this instance to
track deadlocks and delete it altogether.

You decide.

Hope this helps.

Paul
<vi******@gmail.comwrote in message
news:11*********************@k78g2000cwa.googlegro ups.com...
Hi group,

Have a problem with event monitor so my db2diag.log is getting filled
like any thing..

Running DB2 V8.1 Fixpack 6 in AIX server.

Created a event monitor and redirecting it's output to a file..getting
error like

2007-02-20-00.06.52.470942 Instance:***** Node:000
PID:1229054(db2agent (*****) 0) TID:1 Appid:*LOCAL.*****.
0209B0000649
database monitor sqm___start_evmon Probe:32 Database:*****

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x840D000C".

PID:1229054 TID:1 Node:000 Title: event monitor name
0x20066B38 : 4445 4144 4C4F 434B 5F45 5654 53 DEADLOCK_EVTS

PID:1229054 TID:1 Node:000 Title: event monitor target
0x20066B60 : 2F68 6F6D 652F 6475 6D66 6370 312F 6D66 /home/dum/mf
0x20066B70 : 6330 3170 312F 6475 6D66 6370 312F 4E4F c/dum/NO
0x20066B80 : 4445 3030 3030 2F53 514C 3030 3030 312F DE0000/
SQL00001/
0x20066B90 : 6462 3265 7665 6E74 2F44 4C4F 434B 53 db2event/
DLOCKS

2007-02-20-00.06.52.500447 Instance:dumfcp1 Node:000
PID:1229054(db2agent (*****) 0) TID:1 Appid:*LOCAL.*****.
0209B0000649
database monitor sqm___evmgr::log_ev_err Probe:1 Database:*****

DiagData
0x2FF1B410 : 0x840D000C ....

As I got repeated error like this, I turned off the event monitor, but
still my db2diag.log is getting filled with the above error message?

Queries:

Is it problem with starting the event monitor?
problem with redirecting the data to file?
some other issue?

Thanks in advance..
vj_dba

Feb 20 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: JS | last post by:
I have v8.1 fix5 using Win2k AS on 7 node logical system. I create event monitor writing to file and turn it on. Using application, I connect to db and navigate from screen to screen, generating...
1
by: Rohit Raghuwanshi | last post by:
Hello all, we are running a delphi application with DB2 V8.01 which is causing deadlocks when rows are being inserted into a table. Attaching the Event Monitor Log (DEADLOCKS WITH DETAILS) here....
3
by: hikums | last post by:
I dropped the db2detaildeadlock event monitor without flushing the events that were full hoping dropping it will clear the messages also. I now understand this is a default monitor that I should...
4
by: yoyo | last post by:
Is there any way in DB2 to get the exact command. I have an event monitor I created for statments, and all the statment values are filled with a question mark. I was using this at another site...
3
by: datapro01 | last post by:
I am having difficulty understanding the relationship between the dbm event monitor switches and the db event monitor switches. If a monitoring application (Quest, BMC etc) turns on an dbm event...
4
by: Raj | last post by:
Can we create an event monitor for statements in a partitioned environment? CREATE EVENT MONITOR stmt_event FOR STATEMENTS WRITE TO FILE '/home/rajm/event' ON PARTITION 0 GLOBAL DB21034E ...
1
by: Jo | last post by:
Hi. I have a few questions regd event monitoring. Would appreciate some assistance with this. 1. Does the event monitor only insert data into the event monitoring tables once the connection has...
3
by: shorti | last post by:
Hello all, I am running with DB2 UDB V8 on AIX. I am trying to track down what appears to be a lock issue. I turned EVENT MONITOR on with all the options. It doesnt give me the detailed...
1
by: rjha94 | last post by:
$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...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.