....... 发表于 2009-04-13 15:25

DB2今天down了两次,db2diag.log日志如下,谁帮咱分析分析

2009-04-13-15.29.16.456732+540 I13059976G406      LEVEL: Event
PID   : 7063               TID: 3005639168PROC : 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: 3005639168PROC : 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:
0xB4ACFD19 /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x94FD19
0xB75D8DF0 /lib/tls/libpthread.so.0 + 0xADF0
0xB4AD1276 /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x951276
0xB4AD031A sqloSpawnEDU + 0x400
0xB4672AF3 _Z15sqlcctcpconnmgrP15SQLCC_CONNMGR_TP9sqlf_kcfd + 0x5C3
0xB4672232 sqlcctcp_start_listen + 0x4A
0xB46707BB _Z10sqlccstrtsP9sqlf_kcfdP15SQLCC_CONNMGR_TRt + 0x2E7
0x0804DF9C _Z15sqleInitSysCtlrPi + 0xDB4
0x0804D04F _Z11sqleSysCtlrv + 0x3F
0xB4ACC4BB sqloRunInstance + 0x90B

2009-04-13-15.32.42.898542+540 E13061359G512      LEVEL: Severe
PID   : 20258                TID: 3005639168PROC : db2tcpcm 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503CAn 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: 3005639168PROC : 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: 3005639168PROC : 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:
0xB4ACFD19 /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x94FD19
0xB75D8DF0 /lib/tls/libpthread.so.0 + 0xADF0
0xB4AD1276 /opt/IBM/db2/V8.1/lib/libdb2e.so.1 + 0x951276
0xB4AD031A sqloSpawnEDU + 0x400
0xB4672AF3 _Z15sqlcctcpconnmgrP15SQLCC_CONNMGR_TP9sqlf_kcfd + 0x5C3
0xB4672232 sqlcctcp_start_listen + 0x4A
0xB46707BB _Z10sqlccstrtsP9sqlf_kcfdP15SQLCC_CONNMGR_TRt + 0x2E7
0x0804DF9C _Z15sqleInitSysCtlrPi + 0xDB4
0x0804D04F _Z11sqleSysCtlrv + 0x3F
0xB4ACC4BB sqloRunInstance + 0x90B

2009-04-13-15.32.48.213359+540 E13063754G512      LEVEL: Severe
PID   : 20257                TID: 3005639168PROC : db2tcpcm 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503CAn 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: 3005639168PROC : 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: 3005639168PROC : 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: 3005639168PROC : 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: 3005639168PROC : 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: 3005639168PROC : 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: 3005639168PROC : 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: 3005639168PROC : 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: 3005639168PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:490
MESSAGE : ADM0503CAn 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: 3005639168PROC : 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: 3005639168PROC : 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: 3005639168PROC : 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 -920717引起的

xx_adam 发表于 2009-04-18 07:56

ADM0503C   已知错误,升一下级吧
页: [1]
查看完整版本: DB2今天down了两次,db2diag.log日志如下,谁帮咱分析分析