It's all about the answers!

Ask a question

RTC 3.0.1 experience DB2 crashes using the Datawarehouse db


Sonya Purcell (23122) | asked Jun 27 '11, 5:58 a.m.
RTC3.0.1 installed along with RQM and RRC applications.
DB2 Server 9.5 FP5 hosts 3 db's for this config and 11 in total.
5 db2 crashes have occurred since the RTC3.0.1 install and the creation of the data warehouse db. Has anyone experiences issues with DB2 and the Data warehouse db?
Out of Memory failure was idenitfied from db2diag.log on one crash and this value was reduced on the data warehouse db but the crash on DB2 is still happening.
No more out of memory errors appearing in db2diag.log but
2011-06-27-04.14.07.968000-240 I283556359H563 LEVEL: Severe
PID : 3160 TID : 6040 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JAZZ_2_1
APPHDL : 0-200 APPID: *LOCAL.DB2.110627081417
AUTHID : DB2ADMIN
EDUID : 6040 EDUNAME: db2evmti (JAZZ_DEADLOCKS) 0
FUNCTION: DB2 UDB, database monitor, sqm_tablist::sqm_evmon_tablist, probe:20
RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT DETECTED"
DIA8003C The interrupt has been received.

2011-06-27-04.14.07.984000-240 I283556924H579 LEVEL: Severe
PID : 3160 TID : 6040 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JAZZ_2_1
APPHDL : 0-200 APPID: *LOCAL.DB2.110627081417
AUTHID : DB2ADMIN
EDUID : 6040 EDUNAME: db2evmti (JAZZ_DEADLOCKS) 0
FUNCTION: DB2 UDB, database monitor, sqm_tablist::sqm_evmon_tablist, probe:21
DATA #1 : String, 114 bytes
Event Monitor Name: JAZZ_DEADLOCKS;
TableName: CONNHEADER_JAZZ_DEADLOCKS;
Error while accessing the SQL catalog!

Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.