查询大SQL时,时常无返回结果。业内专家帮忙诊断一下,日志如下:
2011-12-27-17.59.07.311685+480 I359094057A502 LEVEL: Error
PID : 24576134 TID : 26218 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-84 APPID: A8013C66.P3B7.111227000421
AUTHID : DB2INST1
EDUID : 26218 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempSubActions, probe:5551
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2011-12-27-17.59.07.311862+480 I359094560A502 LEVEL: Error
PID : 24576134 TID : 26218 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-84 APPID: A8013C66.P3B7.111227000421
AUTHID : DB2INST1
EDUID : 26218 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempSubActions, probe:5551
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2011-12-27-17.59.07.312040+480 I359095063A502 LEVEL: Error
PID : 24576134 TID : 26218 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-84 APPID: A8013C66.P3B7.111227000421
AUTHID : DB2INST1
EDUID : 26218 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempSubActions, probe:5551
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2011-12-27-17.59.07.312218+480 I359095566A502 LEVEL: Error
PID : 24576134 TID : 26218 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-84 APPID: A8013C66.P3B7.111227000421
AUTHID : DB2INST1
EDUID : 26218 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempSubActions, probe:5551
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2011-12-27-17.59.07.312420+480 I359096069A502 LEVEL: Error
PID : 24576134 TID : 26218 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-84 APPID: A8013C66.P3B7.111227000421
AUTHID : DB2INST1
EDUID : 26218 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempPostCleanup, probe:140
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2011-12-27-17.59.07.312574+480 I359096572A491 LEVEL: Error
PID : 24576134 TID : 26218 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-84 APPID: A8013C66.P3B7.111227000421
AUTHID : DB2INST1
EDUID : 26218 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrbck_dps, probe:350
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2011-12-27-17.59.07.312713+480 I359097064A488 LEVEL: Severe
PID : 24576134 TID : 26218 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-84 APPID: A8013C66.P3B7.111227000421
AUTHID : DB2INST1
EDUID : 26218 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:500
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2011-12-27-17.59.07.312852+480 I359097553A487 LEVEL: Severe
PID : 24576134 TID : 26218 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-84 APPID: A8013C66.P3B7.111227000421
AUTHID : DB2INST1
EDUID : 26218 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:57
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2011-12-27-17.59.07.312991+480 I359098041A487 LEVEL: Error
PID : 24576134 TID : 26218 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-84 APPID: A8013C66.P3B7.111227000421
AUTHID : DB2INST1
EDUID : 26218 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrcom, probe:350
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2011-12-27-18.01.59.773466+480 I359098529A1644 LEVEL: Event
PID : 17760472 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0x0FFFFFFFFFFF4D60 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x0FFFFFFFFFFF4D70 : 716C 6C69 622F 6164 6D2F 6462 3273 746F qllib/adm/db2sto
0x0FFFFFFFFFFF4D80 : 7032 004E 4F4D 5347 0053 4E00 0000 0000 p2.NOMSG.SN.....
0x0FFFFFFFFFFF4D90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2011-12-27-18.01.59.796092+480 I359100174A399 LEVEL: Event
PID : 13828288 TID : 1 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:65
DATA #1 : String, 31 bytes
Deactivate phase is in progress
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFF9FBC : 0000 0001 ....
2011-12-27-18.01.59.796880+480 I359100574A418 LEVEL: Event
PID : 13828288 TID : 1 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFF9FBC : 0000 0001 ....
2011-12-27-18.01.59.796991+480 I359100993A299 LEVEL: Event
PID : 13828288 TID : 1 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2011-12-27-18.01.59.797095+480 I359101293A314 LEVEL: Event
PID : 13828288 TID : 1 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2011-12-27-18.02.03.170424+480 I359101608A364 LEVEL: Warning
PID : 24576134 TID : 14909 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 14909 EDUNAME: db2logmgr (NCHRB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
MESSAGE : Started archive for log file S0000111.LOG.
2011-12-27-18.02.03.267127+480 I359101973A487 LEVEL: Warning
PID : 24576134 TID : 14909 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 14909 EDUNAME: db2logmgr (NCHRB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
MESSAGE : Completed archive for log file S0000111.LOG to
/data/archive/db2inst1/NCHRB/NODE0000/C0000000/ from
/data/db2inst1/NODE0000/SQL00001/SQLOGDIR/.
2011-12-27-18.02.03.497752+480 I359102461A429 LEVEL: Error
PID : 24576134 TID : 2057 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2057 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:155
MESSAGE : DIA3208E Error encountered in TCP/IP protocol support. TCP/IP
function "close". Socket was "8". Errno was "9".
2011-12-27-18.02.03.497762+480 I359102891A429 LEVEL: Error
PID : 24576134 TID : 1800 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1800 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:155
MESSAGE : DIA3208E Error encountered in TCP/IP protocol support. TCP/IP
function "close". Socket was "8". Errno was "9".
2011-12-27-18.02.03.497753+480 I359103321A429 LEVEL: Error
PID : 24576134 TID : 2571 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2571 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:155
MESSAGE : DIA3208E Error encountered in TCP/IP protocol support. TCP/IP
function "close". Socket was "8". Errno was "9".
2011-12-27-18.02.03.497901+480 I359103751A429 LEVEL: Error
PID : 24576134 TID : 2314 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2314 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:155
MESSAGE : DIA3208E Error encountered in TCP/IP protocol support. TCP/IP
function "close". Socket was "8". Errno was "9".
2011-12-27-18.02.03.497927+480 I359104181A429 LEVEL: Error
PID : 24576134 TID : 2828 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2828 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:155
MESSAGE : DIA3208E Error encountered in TCP/IP protocol support. TCP/IP
function "close". Socket was "8". Errno was "9".
2011-12-27-18.02.03.499530+480 I359104611A316 LEVEL: Event
PID : 13828288 TID : 1 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2011-12-27-18.02.03.499691+480 I359104928A335 LEVEL: Event
PID : 13828288 TID : 1 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : unsigned integer, 4 bytes
0
2011-12-27-18.02.03.521036+480 I359105264A453 LEVEL: Warning
PID : 19595476 TID : 258 PROC : db2wdog 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x07000000003FDE70 : 0000 0000 ....
2011-12-27-18.02.03.521365+480 I359105718A329 LEVEL: Error
PID : 15794276 TID : 1 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x83000024=-2097151964
2011-12-27-18.02.03.521311+480 I359106048A343 LEVEL: Error
PID : 11665604 TID : 1 PROC : db2fmp (idle) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2fmp (idle) 0
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x83000024=-2097151964
2011-12-27-18.02.03.531819+480 I359106392A458 LEVEL: Error
PID : 11665604 TID : 1 PROC : db2fmp (idle) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2fmp (idle) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFEFE8 : 0000 0000 ....
2011-12-27-18.02.03.521316+480 I359106851A343 LEVEL: Error
PID : 17629332 TID : 1 PROC : db2fmp (idle) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2fmp (idle) 0
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x83000024=-2097151964
2011-12-27-18.02.03.541853+480 I359107195A458 LEVEL: Error
PID : 17629332 TID : 1 PROC : db2fmp (idle) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2fmp (idle) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFEFE8 : 0000 0000 ....
2011-12-27-18.02.03.521335+480 I359107654A337 LEVEL: Error
PID : 23461940 TID : 1286 PROC : db2fmp (C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1286 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x83000024=-2097151964
2011-12-27-18.02.03.521335+480 I359107992A337 LEVEL: Error
PID : 23461940 TID : 772 PROC : db2fmp (C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 772 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x83000024=-2097151964
2011-12-27-18.02.03.521437+480 I359108330A337 LEVEL: Error
PID : 23461940 TID : 1029 PROC : db2fmp (C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1029 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x83000024=-2097151964
2011-12-27-18.02.03.521434+480 I359108668A337 LEVEL: Error
PID : 23461940 TID : 1 PROC : db2fmp (C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x83000024=-2097151964
2011-12-27-18.02.03.551899+480 I359109006A452 LEVEL: Error
PID : 23461940 TID : 1286 PROC : db2fmp (C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1286 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0x0000000110671E78 : 0000 0000 ....
2011-12-27-18.02.03.552052+480 I359109459A452 LEVEL: Error
PID : 23461940 TID : 772 PROC : db2fmp (C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 772 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0x00000001102DCE78 : 0000 0000 ....
2011-12-27-18.02.03.552197+480 I359109912A452 LEVEL: Error
PID : 23461940 TID : 1029 PROC : db2fmp (C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1029 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0x00000001104E8E78 : 0000 0000 ....
2011-12-27-18.02.03.552463+480 I359110365A465 LEVEL: Warning
PID : 23461940 TID : 1286 PROC : db2fmp (C) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1286 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : Thread of db2fmp terminated with nonzero rc
DATA #1 : Hexdump, 4 bytes
0x000000011067258C : FFFF FB95 ....
2011-12-27-18.02.04.167751+480 E359110831A313 LEVEL: Event
PID : 13828288 TID : 1 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2011-12-27-18.02.04.209982+480 I359111145A305 LEVEL: Event
PID : 17760472 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:190
DATA #1 :
Single node stopped [-1064].
2011-12-27-18.02.07.061910+480 I359111451A313 LEVEL: Event
PID : 15794278 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:21
DATA #1 :
Single node instance [0] is starting
2011-12-27-18.02.07.073867+480 I359111765A1645 LEVEL: Event
PID : 15794278 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x0FFFFFFFFFFF4D90 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x0FFFFFFFFFFF4DA0 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0x0FFFFFFFFFFF4DB0 : 7232 004E 4F4D 5347 0000 0000 0000 0000 r2.NOMSG........
0x0FFFFFFFFFFF4DC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4E80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2011-12-27-18.02.07.196897+480 E359113411A324 LEVEL: Info
PID : 23658702 TID : 1 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemProt_enableMemoryProtection, probe:0
MESSAGE : Storage key memory protection is not enabled.
2011-12-27-18.02.09.070688+480 I359113736A531 LEVEL: Event
PID : 22085870 TID : 258 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10
START : Starting FCM Buffer Manager
1 resource group(s).
128 buffers allocated.
Maximum number of buffers supported is 8192.
Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 925712 bytes.
2011-12-27-18.02.09.071415+480 I359114268A538 LEVEL: Event
PID : 22085870 TID : 258 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10
START : Starting FCM Channel Manager
1 resource group(s).
128 channels allocated.
Maximum number of channels supported is 8192.
Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 507928 bytes.
2011-12-27-18.02.09.071777+480 I359114807A537 LEVEL: Event
PID : 22085870 TID : 258 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10
START : Starting FCM Session Manager
1 resource group(s).
128 sessions allocated.
Maximum number of sessions supported is 64000.
Total session manager memory required for 1 logical and 0 fail-over partitions is 1687552 bytes.
2011-12-27-18.02.09.072498+480 I359115345A418 LEVEL: Event
PID : 22085870 TID : 258 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500
START : FCM infrastructure started
FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IPv4
2011-12-27-18.02.09.535562+480 E359115764A1217 LEVEL: Error (OS)
PID : 22085870 TID : 258 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:130
CALLED : OS, -, dlopen
OSERR : ENOEXEC (8) "Exec format error"
MESSAGE : Attempt to load specified library failed.
DATA #1 : Library name or path, 40 bytes
/home/db2inst1/sqllib/lib64/libdb2iocp.a
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
2
DATA #3 : String, 627 bytes
0509-130 Symbol resolution failed for /home/db2inst1/sqllib/lib64/libdb2iocp.a because:
0509-136 Symbol CreateIoCompletionPort (number 0) is not exported from
dependent module /unix.
0509-136 Symbol GetQueuedCompletionStatus (number 1) is not exported from
dependent module /unix.
0509-136 Symbol GetMultipleCompletionStatus (number 2) is not exported from
dependent module /unix.
0509-022 Cannot load module /home/db2inst1/sqllib/lib64/libdb2iocp.a.
0509-026 System error: Cannot run a file that does not have a valid format.
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
2011-12-27-18.02.09.536015+480 E359116982A910 LEVEL: Error (OS)
PID : 22085870 TID : 258 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:140
CALLED : OS, -, dlopen
OSERR : ENOEXEC (8) "Exec format error"
MESSAGE : Attempt to load specified library augmented with object name failed.
DATA #1 : Library name or path, 50 bytes
/home/db2inst1/sqllib/lib64/libdb2iocp.a(shr_64.o)
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
262146
DATA #3 : String, 278 bytes
0509-022 Cannot load module /home/db2inst1/sqllib/lib64/libdb2iocp.a(shr_64.o).
0509-153 File /home/db2inst1/sqllib/lib64/libdb2iocp.a is not an archive or
the file could not be read properly.
0509-026 System error: Cannot run a file that does not have a valid format.
2011-12-27-18.02.09.536182+480 I359117893A568 LEVEL: Severe
PID : 22085870 TID : 258 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloLioInitIocp, probe:200
CALLED : DB2 UDB, oper system services, sqloLoadModule
RETCODE : ZRC=0x870F009B=-2029059941=SQLO_MOD_LOAD_FAILED
"Dynamic library load failed."
DATA #1 : Library name or path, 12 bytes
libdb2iocp.a
DATA #2 : Library Search Path, 27 bytes
/home/db2inst1/sqllib/lib64
2011-12-27-18.02.09.536398+480 E359118462A406 LEVEL: Warning
PID : 22085870 TID : 258 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloStartAIOCollectorEDUs, probe:30
MESSAGE : ADM0513W db2start succeeded. However, no I/O completion port (IOCP)
is available.
2011-12-27-18.02.10.553622+480 E359118869A1222 LEVEL: Event
PID : 23658702 TID : 1 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 152 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL09070"
with level identifier "08010107".
Informational tokens are "DB2 v9.7.0.0", "s090521", "AIX6497", Fix Pack "0".
DATA #2 : System Info, 224 bytes
System: AIX localhost 1 6 00F70FEE4C00
CPU: total:32 online:32 Threading degree per core:2
Physical Memory(MB): total:31616 free:4080
Virtual Memory(MB): total:39808 free:12242
Swap Memory(MB): total:8192 free:8162
Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304
shmMax:68719476736 shmMin:1 shmIDs:131072
shmSegments:68719476736 semIDs:131072 semNumPerID:65535
semOps:1024 semMaxVal:32767 semAdjustOnExit:16384
Cur data size (bytes) = 0x7FFFFFFFFFFFFFFF
Cur stack size (bytes) = 0x0000000100000000
Cur core size (bytes) = 0x00000000FFFFFFFF
nofiles (descriptors) = 0x7FFFFFFFFFFFFFFF
2011-12-27-18.02.10.564224+480 I359120092A500 LEVEL: Event
PID : 22085870 TID : 3599 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IUFO
APPHDL : 0-7 APPID: A8013C69.A14F.111227100210
AUTHID : DB2INST1
EDUID : 3599 EDUNAME: db2agent (IUFO) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB IUFO : "Database_memory" From: "715520" To: "686448"
2011-12-27-18.02.11.226515+480 I359120593A504 LEVEL: Event
PID : 22085870 TID : 5142 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-8 APPID: A8013C66.PF6F.111227100211
AUTHID : DB2INST1
EDUID : 5142 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB NCHRB : "Database_memory" From: "1131189" To: "1081680"
2011-12-27-18.02.11.257727+480 E359121098A414 LEVEL: Info
PID : 22085870 TID : 5913 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
EDUID : 5913 EDUNAME: db2loggr (NCHRB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog, probe:1440
DATA #1 :
Cleaning up logs from RenameArchNum 111 to delLimit 112.
2011-12-27-18.02.11.413971+480 E359121513A465 LEVEL: Event
PID : 22085870 TID : 3599 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IUFO
APPHDL : 0-7 APPID: A8013C69.A14F.111227100210
AUTHID : DB2INST1
EDUID : 3599 EDUNAME: db2agent (IUFO) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1008
DATA #1 :
Starting STMM log from file number 22
2011-12-27-18.02.11.414269+480 I359121979A575 LEVEL: Warning
PID : 22085870 TID : 3599 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IUFO
APPHDL : 0-7 APPID: A8013C69.A14F.111227100210
AUTHID : DB2INST1
EDUID : 3599 EDUNAME: db2agent (IUFO) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmStartSortDbMonitorIfNecessary, probe:1583
MESSAGE : STMM Sort Memory Tuning cannot be activated because the Database
Manager Configuration Parameter SHEAPTHRES is not set to 0.
2011-12-27-18.02.12.291971+480 I359122555A577 LEVEL: Warning
PID : 22085870 TID : 5142 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-8 APPID: A8013C66.PF6F.111227100211
AUTHID : DB2INST1
EDUID : 5142 EDUNAME: db2agent (NCHRB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmStartSortDbMonitorIfNecessary, probe:1583
MESSAGE : STMM Sort Memory Tuning cannot be activated because the Database
Manager Configuration Parameter SHEAPTHRES is not set to 0.
2011-12-27-18.02.12.359301+480 E359123133A804 LEVEL: Warning
PID : 22085870 TID : 25703 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-81 APPID: *LOCAL.DB2.111227100324
AUTHID : DB2INST1
EDUID : 25703 EDUNAME: db2evmgi (DB2DETAILDEADLOCK) 0
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:20
DATA #1 :
Reserved heap size exceeded for Database Monitor Heap (MON_HEAP_SZ) on node 0,
allocating additional unreserved memory.
Requested block size : 69656 bytes.
Physical heap size : 458752 bytes.
Configured heap size : 393216 bytes.
Unreserved memory used by heap : 65536 bytes.
Unreserved memory left in set : 10289152 bytes.
2011-12-27-18.05.11.423604+480 I359123938A497 LEVEL: Event
PID : 22085870 TID : 6941 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : IUFO
APPHDL : 0-9 APPID: *LOCAL.DB2.111227100212
AUTHID : DB2INST1
EDUID : 6941 EDUNAME: db2stmm (IUFO) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB IUFO: "Database_memory" From: "686448" To: "715520"
2011-12-27-18.05.12.301155+480 I359124436A502 LEVEL: Event
PID : 22085870 TID : 16708 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : NCHRB
APPHDL : 0-46 APPID: *LOCAL.DB2.111227100249
AUTHID : DB2INST1
EDUID : 16708 EDUNAME: db2stmm (NCHRB) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB NCHRB: "Database_memory" From: "1081680" To: "1125041"
2011-12-27-18.07.12.402176+480 E359124939A666 LEVEL: Error
PID : 14352614 TID : 772 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
EDUID : 772 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10500E Health indicator "Monitor Heap Utilization"
("db2.mon_heap_util") breached the "upper" alarm threshold of "95 %"
with value "150 %" on "instance" "db2inst1". Calculation:
"((db2.mon_heap_cur_size/db2.mon_heap_max_size)*100);" = "((589824 /
393216) * 100)" = "150 %". History (Timestamp, Value, Formula): "()"附件:
db2diag.rar (4.6 MB)