DB2 8.2 Win2003
I'm experiencing some unexplained instance failures on a soon to go live production DB, which is obviously of great concern.
The latest failure was during an overnight scheduled backup with quiesce.
Basically db2diag.log shows that the database encountered some errors around the same time as the backup and eventually issued a dbstop command.
Some highlights:
.
.
.
2006-02-23-23.45.08.601000+600 E982259H405 LEVEL: Error
PID : 2724 TID : 6024 PROC : db2syscs.exe
INSTANCE: SOL NODE : 000 DB : TERRA
APPHDL : 0-1118 APPID: *LOCAL.SOL.060223134517
FUNCTION: DB2 UDB, base sys utilities, sqleDatabaseQuiesce, probe:2
MESSAGE : ADM7507W Database quiesce request has completed successfully.
.
.
.
2006-02-23-23.45.09.945000+600 I982666H481 LEVEL: Error
PID : 2724 TID : 2372 PROC : db2syscs.exe
INSTANCE: SOL NODE : 000 DB : TERRA
APPHDL : 0-342 APPID: *LOCAL.SOL.060223134516
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x27F557E6 : 0000
.
.
.
.
2006-02-23-23.45.10.070000+600 I987193H171 LEVEL: Severe
PID:2724 TID:2372 NODE:000 Title: **** DRDA ASCB ****
Dump File:C:\PROGRA~1\IBM\SQLLIB\SOL\27242372.000
.
.
.
2006-02-23-23.42.47.415000+600 I981436H430 LEVEL: Severe
PID : 2724 TID : 6024 PROC : db2syscs.exe
INSTANCE: SOL NODE : 000 DB : TERRA
APPHDL : 0-1083 APPID: C0A80A71.A405.00E5C3134303
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"
.
.
.
2006-02-23-23.45.10.820000+600 I991422H489 LEVEL: Warning
PID : 2724 TID : 2372 PROC : db2syscs.exe
INSTANCE: SOL NODE : 000 DB : TERRA
APPHDL : 0-342 APPID: *LOCAL.SOL.060223134516
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x27F5FC90 : 0000 0000