早上发现db2数据库意外宕机,操作系统windows server 2008 R2,数据库版本V10.1
通过服务器内存监控发现宕机之前操作系统内存猛涨,截图及日志请看附件。
2015-03-10-21.43.46.328000+480 I298740F534 LEVEL: Event
PID : 11336 TID : 17496 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : COMMON
APPHDL : 0-6320 APPID: 10.1.111.8.65393.150310120230
AUTHID : ADMINISTRATOR HOSTNAME: SZDBSERA
EDUID : 17496 EDUNAME: db2agent (COMMON) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScriptDirect, probe:150
STOP : Completed invoking D:ProgramIBMSQLLIBbindb2cos_trap.bat
2015-03-10-21.43.46.328000+480 I299276F614 LEVEL: Error
PID : 11336 TID : 17496 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : COMMON
APPHDL : 0-6320 APPID: 10.1.111.8.65393.150310120230
AUTHID : ADMINISTRATOR HOSTNAME: SZDBSERA
EDUID : 17496 EDUNAME: db2agent (COMMON) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x0000000034E8C962 : 0000 ..
2015-03-10-21.43.46.328000+480 I299892F621 LEVEL: Error
PID : 11336 TID : 17496 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : COMMON
APPHDL : 0-6320 APPID: 10.1.111.8.65393.150310120230
AUTHID : ADMINISTRATOR HOSTNAME: SZDBSERA
EDUID : 17496 EDUNAME: db2agent (COMMON) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:2
MESSAGE : Error in agent servicing application with coor_agent_index:
DATA #1 : Hexdump, 2 bytes
0x0000000034E8C960 : B018 ..
2015-03-10-21.43.46.328000+480 I300515F614 LEVEL: Error
PID : 11336 TID : 17496 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : COMMON
APPHDL : 0-6320 APPID: 10.1.111.8.65393.150310120230
AUTHID : ADMINISTRATOR HOSTNAME: SZDBSERA
EDUID : 17496 EDUNAME: db2agent (COMMON) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:3
MESSAGE : Error in agent servicing application with CLIENT PID:
DATA #1 : Hexdump, 1 bytes
0x0000000034E8C940 : 30 0
附件:
db2diag.log (473.86 KB)