Now i think i might have accidentally deleted the event monitor DB2DETAILDEADLOCK and so i keep getting an error that path not found when the system tries to initialize the monitor. is there any way around this error??
2006-02-08-18.44.52.765000+330 I7567H356 LEVEL: Warning
PID : 1312 TID : 2068 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PERFDB03
APPHDL : 0-7 APPID: *LOCAL.DB2.060208124923
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:100
MESSAGE : Restore Complete.
2006-02-08-18.44.55.203000+330 I7925H314 LEVEL: Warning
PID : 1312 TID : 2132 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCallGIFL, probe:1250
MESSAGE : New log extent 22337, PId 1141213589, FirstLSN 002981ABE000
2006-02-08-18.46.56.796000+330 I8241H323 LEVEL: Warning
PID : 1312 TID : 2860 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 -2079522804
2006-02-08-18.46.56.812000+330 I8566H401 LEVEL: Severe
PID : 1312 TID : 3704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PERFDB03
APPHDL : 0-18 APPID: *LOCAL.DB2.060208131455
FUNCTION: DB2 UDB, database monitor, sqm___start_evmon, probe:40
RETCODE : ZRC=0x840D000C=-2079522804=SQLM_RC_EVIO2 "path not found"
2006-02-08-18.46.56.812000+330 I8969H458 LEVEL: Severe
PID : 1312 TID : 3704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PERFDB03
APPHDL : 0-18 APPID: *LOCAL.DB2.060208131455
MESSAGE : event monitor name
DATA #1 : Hexdump, 17 bytes
0x012D9608 : 4442 3244 4554 4149 4C44 4541 444C 4F43 DB2DETAILDEADLOC
0x012D9618 : 4B K
2006-02-08-18.46.56.812000+330 I9429H541 LEVEL: Severe
PID : 1312 TID : 3704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PERFDB03
APPHDL : 0-18 APPID: *LOCAL.DB2.060208131455
MESSAGE : event monitor target
DATA #1 : Hexdump, 40 bytes
0x012D9630 : 443A 5C44 4232 5C4E 4F44 4530 3030 305C D:\DB2\NODE0000\
0x012D9640 : 5351 4C30 3030 3031 5C44 4232 4556 454E SQL00001\DB2EVEN
0x012D9650 : 545C 444C 4F43 4B53 T\DLOCKS
2006-02-08-18.46.56.812000+330 I9972H447 LEVEL: Severe
PID : 1312 TID : 3704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PERFDB03
APPHDL : 0-18 APPID: *LOCAL.DB2.060208131455
FUNCTION: DB2 UDB, database monitor, sqm___evmgr::log_ev_err, probe:1
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0ACB9088 : 0C00 0D84
thanks,
______________________________
Anand Kaushal
Software Engineer - Database
Lionbridge
5th Floor, Spectra Building,
Hiranandani Business Park,
Powai, Mumbai - 400 076
+91-22-55567000x7079 (office)
+91-9819210090 (mobile)
www.lionbridge.com
DB2 & UDB email list listserv db2-l LazyDBA home page