I believe there is an APAR on this. Check it out on the IBM Support site. I am at home and don't have full access. I've seen the message even when the event monitor was disabled (state 0).
Hal Steiner
-----Original Message-----
From: DANIEL CALLAHAN <db2udbdba-ezmlmshield-x63742680.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Fri, 28 Oct 2005 08:32:19 -0400
Subject: Re: Event monitor, DB2DETAILDEADLOCK
basically in the default detail lock event monitor you are running out of
space or not finding a place to
put the temp files (it looks like there isnt a target)
if you want to get rid of the messages, look at the target location for
this and expand it or if you want to
turn it off
db2 "set event monitor DB2DETAILDEADLOCK state 0"
Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
"Otfrid Altfeld "
<db2udbdba-ezmlms
hield-x10528745.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
10/28/2005 04:46
AM Subject
Event monitor, DB2DETAILDEADLOCK
Hi all.
When having a look at db2diag.log I see the following message appearing in
short intervals:
2005-10-28-09.27.05.625000+120 I480754784H323 LEVEL: Warning
PID : 1224 TID : 1652 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, database monitor, sqm___sqlmeiot, probe:7
MESSAGE : target type 0 failed to open DB2DETAILDEADLOCK with rc
-2146631637
When executing
SELECT * FROM syscat.eventmonitors
I get the following:
EVMONNAME DEFINER TARGET_TYPE TARGET MAXFILES
MAXFILESIZE BUFFERSIZE IO_MODE WRITE_MODE ...
----------------- ---------- ----------- ----------------- --------
----------- ---------- ------- ---------- ---------
DB2DETAILDEADLOCK owner_name F db2detaildeadlock 20
512 17 B A ...
Does this mean the event monitors is running but has no existing target
file?
When using the Control Center I get no information about event monitors.
What can I do to get rid of these messages?
How can I get information about the event monitor's configuration?
How can I alter the monitor's configuration (i.e. defining a target
file...)?
(DB2: 8.2 Fixpack 7, OS: Windows 2000 Server)
Thanks in advance,
Otfrid
Otfrid Altfeld
Vermittlungstechnik
3U TELECOM AG
Neue Kasseler Straße 62F
D-35039 Marburg
Tel: +49/ (0) 64 21/ 999 - 24 68
Fax: +49/ (0) 64 21/ 999 - 23 45
Email: [Email address protected] <mailto:[Email address protected]
Internet: www.3u.net <http://www.3u.net/>
Jetzt neu: 3U Highspeed-DSL und 3U Internet-Telefonie
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page