RTC 3.0.1 experience DB2 crashes using the Datawarehouse db
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!
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!