Chinaunix

标题: DB2今天down了两次，db2diag.log日志如下，谁帮咱分析分析 [打印本页]

作者: ....... 时间: 2009-04-13 15:25
标题: DB2今天down了两次，db2diag.log日志如下，谁帮咱分析分析
2009-04-13-15.29.16.456732+540 I13059976G406    LEVEL: Event
PID    : 7063                TID  : 3005639168  PROC : db2agent (test) 0
INSTANCE: db2inst1          NODE : 000       DB : test
APPHDL  : 0-507             APPID: C0A81048.H304.090413062916
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE  : CFG DB test: "MaxAppls" <automatic> From: "226" To: "249"

2009-04-13-15.32.42.840353+540 E13060383G975    LEVEL: Severe
PID    : 20258             TID  : 3005639168  PROC : db2tcpcm 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUSIGCHLDHandler, probe:50
DATA #1 : <preformatted>
Detected the death of an EDU with process id 20530
The signal number that terminated this process was 9
Look for trap files (t20530.*) in the dump directory
CALLSTCK:
  [0] 0xB4ACFD19 /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x94FD19
  [1] 0xB75D8DF0 /lib/tls/libpthread.so.0 + 0xADF0
  [2] 0xB4AD1276 /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x951276
  [3] 0xB4AD031A sqloSpawnEDU + 0x400
  [4] 0xB4672AF3 _Z15sqlcctcpconnmgrP15SQLCC_CONNMGR_TP9sqlf_kcfd + 0x5C3
  [5] 0xB4672232 sqlcctcp_start_listen + 0x4A
  [6] 0xB46707BB _Z10sqlccstrtsP9sqlf_kcfdP15SQLCC_CONNMGR_TRt + 0x2E7
  [7] 0x0804DF9C _Z15sqleInitSysCtlrPi + 0xDB4
  [8] 0x0804D04F _Z11sqleSysCtlrv + 0x3F
  [9] 0xB4ACC4BB sqloRunInstance + 0x90B

2009-04-13-15.32.42.898542+540 E13061359G512    LEVEL: Severe
PID    : 20258             TID  : 3005639168  PROC : db2tcpcm 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503C  An unexpected internal processing error has occurred.  ALL
      DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
      Diagnostic information has been recorded.  Contact IBM Support for
      further assistance.

2009-04-13-15.32.42.899168+540 E13061872G905    LEVEL: Severe
PID    : 20258             TID  : 3005639168  PROC : db2tcpcm 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
6
DATA #2 : Siginfo, 128 bytes
0xBFFF3240 : 0600 0000 0000 0000 FAFF FFFF 224F 0000 ............"O..
0xBFFF3250 : 3623 0000 6F95 14C0 6C0E 7EEF 903F 87F5 6#..o...l.~..?..
0xBFFF3260 : 4C31 FFBF 0000 0000 703F 87F5 1B73 13C0 L1......p?...s..
0xBFFF3270 : 1F00 0000 903F 87F5 0000 0000 0095 DDD4 .....?..........
0xBFFF3280 : C0CE FEF7 3B15 16C0 809A F9F5 0095 DDD4 ....;...........
0xBFFF3290 : 0000 0000 0100 0000 0020 87F5 F065 13C0 ......... ...e..
0xBFFF32A0 : A83F 87F5 A03F 87F5 A83F 87F5 0000 0100 .?...?...?......
0xBFFF32B0 : 0000 0000 0000 0100 0000 0000 0020 87F5 ............. ..

2009-04-13-15.32.48.148917+540 E13062778G975    LEVEL: Severe
PID    : 20257             TID  : 3005639168  PROC : db2tcpcm 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUSIGCHLDHandler, probe:50
DATA #1 : <preformatted>
Detected the death of an EDU with process id 20717
The signal number that terminated this process was 9
Look for trap files (t20717.*) in the dump directory
CALLSTCK:
  [0] 0xB4ACFD19 /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x94FD19
  [1] 0xB75D8DF0 /lib/tls/libpthread.so.0 + 0xADF0
  [2] 0xB4AD1276 /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x951276
  [3] 0xB4AD031A sqloSpawnEDU + 0x400
  [4] 0xB4672AF3 _Z15sqlcctcpconnmgrP15SQLCC_CONNMGR_TP9sqlf_kcfd + 0x5C3
  [5] 0xB4672232 sqlcctcp_start_listen + 0x4A
  [6] 0xB46707BB _Z10sqlccstrtsP9sqlf_kcfdP15SQLCC_CONNMGR_TRt + 0x2E7
  [7] 0x0804DF9C _Z15sqleInitSysCtlrPi + 0xDB4
  [8] 0x0804D04F _Z11sqleSysCtlrv + 0x3F
  [9] 0xB4ACC4BB sqloRunInstance + 0x90B

2009-04-13-15.32.48.213359+540 E13063754G512    LEVEL: Severe
PID    : 20257             TID  : 3005639168  PROC : db2tcpcm 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503C  An unexpected internal processing error has occurred.  ALL
      DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
      Diagnostic information has been recorded.  Contact IBM Support for
      further assistance.

2009-04-13-15.32.48.214197+540 E13064267G905    LEVEL: Severe
PID    : 20257             TID  : 3005639168  PROC : db2tcpcm 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
6
DATA #2 : Siginfo, 128 bytes
0xBFFF3240 : 0600 0000 0000 0000 FAFF FFFF 214F 0000 ............!O..
0xBFFF3250 : 3623 0000 6F95 14C0 6C2F 7EEF 903F 92D5 6#..o...l/~..?..
0xBFFF3260 : 4C31 FFBF 0000 0000 703F 92D5 1B73 13C0 L1......p?...s..
0xBFFF3270 : 1F00 0000 903F 92D5 0000 0000 00B5 05D6 .....?..........
0xBFFF3280 : C0CE FEF7 3B15 16C0 80CF 46F5 00B5 05D6 ....;.....F.....
0xBFFF3290 : 0000 0000 0100 0000 0020 92D5 F065 13C0 ......... ...e..
0xBFFF32A0 : A83F 92D5 A03F 92D5 A83F 92D5 0000 0100 .?...?...?......
0xBFFF32B0 : 0000 0000 0000 0100 0000 0000 0020 92D5 ............. ..

2009-04-13-15.33.13.815117+540 I13065173G363    LEVEL: Severe
PID    : 20251             TID  : 3005639168  PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:15
MESSAGE : DiagData
DATA #1 : Hexdump, 15 bytes
0x0805352C : 416E 2045 4455 2063 7261 7368 6564 2E    An EDU crashed.

2009-04-13-15.33.13.815782+540 I13065537G351    LEVEL: Severe
PID    : 20251             TID  : 3005639168  PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFF97A4 : 214F 0000                               !O..

2009-04-13-15.33.13.815884+540 I13065889G351    LEVEL: Severe
PID    : 20251             TID  : 3005639168  PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:17
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFF979C : 0101 0000                               ....

2009-04-13-15.33.13.815972+540 I13066241G351    LEVEL: Severe
PID    : 20251             TID  : 3005639168  PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:18
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFF97A0 : FFFF FFFF                               ....

2009-04-13-15.33.13.840142+540 I13066593G351    LEVEL: Severe
PID    : 20251             TID  : 3005639168  PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:19
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFF9798 : 88FC FFFF                               ....

2009-04-13-15.33.13.840275+540 I13066945G341    LEVEL: Severe
PID    : 20251             TID  : 3005639168  PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleSysCtlr, probe:10
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFF9A44 : 0100 0000                               ....

2009-04-13-15.33.30.784955+540 E13067287G507    LEVEL: Severe
PID    : 20250             TID  : 3005639168  PROC : db2wdog 0 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:490
MESSAGE : ADM0503C  An unexpected internal processing error has occurred.  ALL
      DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
      Diagnostic information has been recorded.  Contact IBM Support for
      further assistance.

2009-04-13-15.33.30.839241+540 I13067795G354    LEVEL: Severe
PID    : 20250             TID  : 3005639168  PROC : db2wdog 0 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:500
MESSAGE : DiagData
DATA #1 : Hexdump, 8 bytes
0xBFFF9D38 : 0201 0000 0900 0000                      ........

2009-04-13-15.33.30.839383+540 I13068150G351    LEVEL: Severe
PID    : 20250             TID  : 3005639168  PROC : db2wdog 0 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFF9A44 : 0201 0000                               ....

2009-04-13-15.33.30.839624+540 I13068502G397    LEVEL: Warning
PID    : 20250             TID  : 3005639168  PROC : db2wdog 0 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0xBFFF9918 : 0000 0000                               ....

作者: xmltiger 时间: 2009-04-15 10:10
被人kill －9 20717引起的

作者: xx_adam 时间: 2009-04-18 07:56
ADM0503C 已知错误,升一下级吧

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)