Hi

Hopefully somebody can shed some light on these two error codes: 0x800D002C and 0x81360012.

Thanks in advance for any help... I'm quite new to DB2 so things like this are quite frustrating.

B.

ERROR 1: 0x800D002C

IT HAPPENS:
About once or twice a day. Usually during backups, or first thing in the morning.

WHAT I FOUND:
IBM gives you this...
Name = SQLM_RC_EVPATH
SQL Code = -1618
Description = path in use

BLURB FROM IBM:
SQL1618N The target path of the specified event monitor is in use by another event monitor.

Explanation: The specified event monitor was created with the same target path as another event monitor. This other event monitor was activated at least once, and has left .evt and/or .ctl files in the target path. These files may be in use by application(s) that are reading the event information they contain.

User Response: If the other event monitor is currently active, deactivate it. After ensuring no application(s) are using the files it created in the target path, remove the files. Then resubmit the SET EVENT MONITOR statement.

Alternatively, recreate the required event monitor, specifying a different target path, and resubmit the SET EVENT MONITOR statement.

sqlcode: -1618

sqlstate: 51026


FROM MY DB2DIAG.LOG:
2004-04-05-09.19.42.859000 InstanceB2 Node:000
PID:193(db2syscs.exe) TID:171 Appid:C0A87D1F.G72E.00FBB9BDB76B
database monitor sqm.start_evmon Probe:32 Database:PFGDEV

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

2004-04-05-09.19.42.968000 InstanceB2 Node:000
PID:193(db2syscs.exe) TID:171 Appid:C0A87D1F.G72E.00FBB9BDB76B
database monitor sqm.evmgr::log_ev_err Probe:1 Database:PFGDEV

DiagData
2c00 0d80 ,..�


FURTHER INFO:
- I do not have any Event Monitors running (AFAIK).
- There are 4 Databases on this Instance. It only happens on this DB (PFGDEV).
- I am very new to DB2 (I'm an Oracle head), but I'm trying!


ERROR 2: 0x81360012

IT HAPPENS:
A few times a week.

WHAT I FOUND:
Nada.

FROM MY DB2DIAG.LOG:
2004-04-05-09.59.45.421000 InstanceB2 Node:000
PID:193(db2syscs.exe) TID:346 Appid:C0A87D1F.G87B.00FBB9E2825D
database monitor sqm.evmgr::log_ev_err Probe:1 Database:PFGDEV

DiagData
2c00 0d80 ,..�

2004-04-05-12.49.07.968000 InstanceB2 Node:000
PID:193(db2syscs.exe) TID:277 Appid:C0A87DB3.A106.002A15113904
DRDA Application Server sqljsDrdaAsDriver Probe:100 Database:BPMDEV

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

Try:
db2 get monitor switches
db2 "select * from syscat.eventmonitors"

And check the "get dbm cfg" to see what the defaults are for the database monitors.

Just to make sure.

Great info.

'db2 get monitor switches' returns:

Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 04-01-2004 18:45:44.000047
Unit of Work Information (UOW) = OFF

... so the 'TimeStamp Information' one is the only thing that is set to 'ON'.


When I do this:
db2 "select * from syscat.eventmonitors"

I get an entry for "DB2DETAILDEADLOCK" in EACH of four Databases on the Instance. TWO of these have the same TARGET viz. D:\DB2\NODE0000\SQL00002\DB2EVENT\db2detaildeadloc k

I have used the following commands to remove this from all four Databases as these are just Dev boxes, but this error makes the Instance stop!!

db2 SET EVENT MONITOR DB2DETAILDEADLOCK STATE 0
db2 DROP EVENT MONITOR DB2DETAILDEADLOCK

Thanks a million ofr you help on this one. I will keep an eye on the Diag Log over the next few days.

Brian.