停止时日志
2014-09-26-13.56.05.755416+480 E63341137E426 LEVEL: Info
PID : 11298 TID : 139829908072784PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : CCDW
APPHDL : 0-46056 APPID: *LOCAL.db2inst1.140926035314
AUTHID : DB2INST1
EDUID : 33163 EDUNAME: db2agent (CCDW) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:838
MESSAGE : Backup complete.
2014-09-26-14.19.57.703865+480 I63341564E1636 LEVEL: Event
PID : 17931 TID : 140373053396736PROC : db2stop
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0x00007FFF2E107F90 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x00007FFF2E107FA0 : 716C 6C69 622F 6164 6D2F 6462 3273 746F qllib/adm/db2sto
0x00007FFF2E107FB0 : 7032 004E 4F4D 5347 0046 4F52 4345 0053 p2.NOMSG.FORCE.S
0x00007FFF2E107FC0 : 4E00 0000 0000 0000 0000 0000 0000 0000 N...............
0x00007FFF2E107FD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E107FE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E107FF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E108000 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E108010 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E108020 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E108030 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E108040 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E108050 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E108060 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E108070 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF2E108080 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2014-09-26-14.19.57.838120+480 I63343201E387 LEVEL: Event
PID : 17933 TID : 140168851097344PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104
DATA #1 : String, 26 bytes
Force phase is in progress
DATA #2 : Hexdump, 4 bytes
0x00007FFFA2A95214 : 0000 0000 ....
2014-09-26-14.19.57.841729+480 I63343589E481 LEVEL: Event
PID : 11298 TID : 139849084430672PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1000
DATA #1 : String, 47 bytes
[Force]->Number of applications to be forced :
DATA #2 : Hexdump, 4 bytes
0x00007F3126FF67C4 : 1900 0000 ....
2014-09-26-14.22.47.855308+480 I63344071E445 LEVEL: Error
PID : 11298 TID : 139849235425616PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 16 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0x00007F312FFFDE14 : 6CE8 FFFF l...
2014-09-26-14.22.47.861137+480 I63344517E445 LEVEL: Error
PID : 11298 TID : 139849235425616PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 16 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0x00007F312FFFDE14 : 6CE8 FFFF l...
2014-09-26-14.22.47.861505+480 I63344963E445 LEVEL: Error
PID : 11298 TID : 139849252202832PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 15 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0x00007F3130FFDE14 : 6CE8 FFFF l...
类似日志一直在重复,只是蓝色部份不同
2014-09-26-14.22.47.868946+480 I63345409E445 LEVEL: Error
PID : 11298 TID : 139849235425616PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 16 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0x00007F312FFFDE14 : 6CE8 FFFF
2014-09-26-14.54.04.375594+480 I63393011E284 LEVEL: Error
PID : 16055 TID : 139977427159376PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x8300002B=-2097151957
2014-09-26-14.54.04.687615+480 I63393296E399 LEVEL: Error
PID : 16055 TID : 139977427159376PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0x00007F4F08D27F20 : 8981 0000 ....
2014-09-26-14.54.04.375153+480 I63393696E284 LEVEL: Error
PID : 16055 TID : 139977818674944PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x8300002B=-2097151957
2014-09-26-14.54.04.764907+480 I63393981E1114 LEVEL: Error
PID : 6126 TID : 140654457903440PROC : db2dasstm
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 Tools, DB2 administration server, MDUtility::connectMD, probe:10
DATA #1 : signed integer, 4 bytes
1
DATA #2 : signed integer, 4 bytes
-1032
DATA #3 : signed integer, 4 bytes
8001
DATA #4 : String, 7 bytes
TOOLSDB
DATA #5 : String, 8 bytes
SYSTOOLS
DATA #6 : String, 4 bytes
NULL
CALLSTCK:
[0] 0x00007FECE083A0A8 pdOSSeLoggingCallback + 0x100
[1] 0x00007FECE57B230C /home/db2inst1/sqllib//lib64/libdb2osse.so.1 + 0x1B230C
[2] 0x00007FECE57B3B28 ossLog + 0xA6
[3] 0x00007FECDD185661 _ZN9MDUtility9connectMDER13ThreadContextPcS2_S2_S2_RiS3_S3_ + 0x58D
[4] 0x00007FECDCF1382D _ZN14MDRetryHandler13getNewContextER13ThreadContextRiS2_S2_ + 0x5B
[5] 0x00007FECDCF102E4 _ZN18JobExecutionThread3runEP7JNIEnv_ + 0xC74
[6] 0x00007FECDCF25757 _ZN6Thread10entryPointEPv + 0x61
[7] 0x00007FECE514E0FB db2dasThreadMain + 0x37
[8] 0x00007FECE4682070 /lib64/libpthread.so.0 + 0x7070
[9] 0x00007FECE3C7B10D clone + 0x6D
2014-09-26-14.54.04.770165+480 I63395096E1172 LEVEL: Error
PID : 6126 TID : 140654457903440PROC : db2dasstm
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 Tools, DB2 administration server, MDUtility::connectMD, probe:50
DATA #1 : String, 10 bytes
MD RC = 1
DATA #2 : String, 16 bytes
SQLCODE = -1032
DATA #3 : String, 16 bytes
SQLSTATE = 8001
DATA #4 : String, 17 bytes
DBName = TOOLSDB
DATA #5 : String, 18 bytes
Schema = SYSTOOLS
DATA #6 : String, 10 bytes
UserID =
DATA #7 : String, 11 bytes
Count = 25
DATA #8 : String, 11 bytes
Limit = 25
CALLSTCK:
[0] 0x00007FECE083A0A8 pdOSSeLoggingCallback + 0x100
[1] 0x00007FECE57B230C /home/db2inst1/sqllib//lib64/libdb2osse.so.1 + 0x1B230C
[2] 0x00007FECE57B3B28 ossLog + 0xA6
[3] 0x00007FECDCF13BA4 _ZN14MDRetryHandler13getNewContextER13ThreadContextRiS2_S2_ + 0x3D2
[4] 0x00007FECDCF102E4 _ZN18JobExecutionThread3runEP7JNIEnv_ + 0xC74
[5] 0x00007FECDCF25757 _ZN6Thread10entryPointEPv + 0x61
[6] 0x00007FECE514E0FB db2dasThreadMain + 0x37
[7] 0x00007FECE4682070 /lib64/libpthread.so.0 + 0x7070
[8] 0x00007FECE3C7B10D clone + 0x6D
[9] 0x0000000000000000 ?unknown + 0x0
2014-09-26-14.54.04.786852+480 I63396269E924 LEVEL: Error
PID : 6126 TID : 140654457903440PROC : db2dasstm
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 Tools, DB2 administration server, JobExecutionThread_run, probe:20
DATA #1 : String, 20 bytes
Scheduler RC = -201
DATA #2 : String, 10 bytes
MD RC = 1
DATA #3 : String, 16 bytes
SQLCODE = -1032
CALLSTCK:
[0] 0x00007FECE083A0A8 pdOSSeLoggingCallback + 0x100
[1] 0x00007FECE57B230C /home/db2inst1/sqllib//lib64/libdb2osse.so.1 + 0x1B230C
[2] 0x00007FECE57B3B28 ossLog + 0xA6
[3] 0x00007FECDCF10D5F _ZN18JobExecutionThread3runEP7JNIEnv_ + 0x16EF
[4] 0x00007FECDCF25757 _ZN6Thread10entryPointEPv + 0x61
[5] 0x00007FECE514E0FB db2dasThreadMain + 0x37
[6] 0x00007FECE4682070 /lib64/libpthread.so.0 + 0x7070
[7] 0x00007FECE3C7B10D clone + 0x6D
[8] 0x0000000000000000 ?unknown + 0x0
[9] 0x0000000000000000 ?unknown + 0x0
2014-09-26-14.54.04.379401+480 E63397194E488 LEVEL: Error (OS)
PID : 17901 TID : 140656758314752PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.140926061811
FUNCTION: DB2 UDB, oper system services, sqlodque, probe:2
MESSAGE : ZRC=0x870F003E=-2029060034=SQLO_QUE_BAD_HANDLE "Bad Queue Handle"
DIA8555C An invalid message queue handle was encountered.
CALLED : OS, -, msgctl OSERR: EINVAL (22)
2014-09-26-14.54.04.983842+480 E63397683E488 LEVEL: Error (OS)
PID : 17901 TID : 140656758314752PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.140926061811
FUNCTION: DB2 UDB, oper system services, sqlodque, probe:2
MESSAGE : ZRC=0x870F003E=-2029060034=SQLO_QUE_BAD_HANDLE "Bad Queue Handle"
DIA8555C An invalid message queue handle was encountered.
CALLED : OS, -, msgctl OSERR: EINVAL (22)
2014-09-26-14.54.04.386236+480 E63398172E288 LEVEL: Error
PID : 11296 TID : 140574262815056PROC : db2wdog 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:90
2014-09-26-14.54.04.993130+480 E63398461E499 LEVEL: Error
PID : 11296 TID : 140574262815056PROC : db2wdog 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerRemoveAllIPCforRow, probe:10
DATA #1 : String, 32 bytes
Freeing IPC resource explicitly:
DATA #2 : Process ID, 4 bytes
28285
DATA #3 : Hexdump, 8 bytes
0x0000000202F5C420 : 0000 0000 0000 0000 ........
2014-09-26-14.54.04.995910+480 E63398961E399 LEVEL: Error
PID : 11296 TID : 140574262815056PROC : db2wdog 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerRemoveAllIPCforRow, probe:20
DATA #1 : String, 22 bytes
IPC resources Address:
DATA #2 : Pointer, 8 bytes
0x0000000210993fc0
2014-09-26-14.54.04.998634+480 E63399361E1101 LEVEL: Error
PID : 11296 TID : 140574262815056PROC : db2wdog 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerRemoveAllIPCforRow, probe:30
DATA #1 : String, 29 bytes
Number of IPC resource found:
DATA #2 : signed integer, 4 bytes
1
DATA #3 : String, 29 bytes
Number of IPC resource freed:
DATA #4 : signed integer, 4 bytes
1
CALLSTCK:
[0] 0x00007FDA14C5631F pdLog + 0x2A9
[1] 0x00007FDA15A9B32B _Z23sqlerRemoveAllIPCforRowP11sqlerFmpRowb + 0x40B
[2] 0x00007FDA15A9BD96 /opt/ibm/db2/V9.7/lib64/libdb2e.so.1 + 0x1AEAD96
[3] 0x00007FDA15A9BE2C _Z23sqlerRemoveFmpFromTableP11sqlerFmpRowb + 0x2A
[4] 0x00007FDA14DC11BC _Z20sqlerReturnFmpToPoolccP14sqlerFmpHandleP8sqeAgent + 0xAFA
[5] 0x000000000040E409 _Z12sqleWatchDogm + 0x93F
[6] 0x000000000040CE26 DB2main + 0xD8E
[7] 0x00007FDA15184071 _Z16sqloEDUMainEntryPcj + 0xF
[8] 0x00007FDA15183741 sqloEDUEntry + 0x849
[9] 0x00007FDA18F94070 /lib64/libpthread.so.0 + 0x7070
收起