银行数据库 services

B2 UDB, catalog services, sqlrl_userTempSubActions, probe:5551

查询大SQL时，时常无返回结果。业内专家帮忙诊断一下，日志如下：2011-12-27-17.59.07.311685+480 I359094057A502 LEVEL: ErrorPID : 24576134 TID : 26218... 显示全部

查询大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)

收起

关注 1

参与16

查看其它 14 个回答top_vip 的回答

top_vip 技术总监 yonyou

db2 get db cfg for database1 | grep "APPLHEAPSZ"
增加APPLHEAPSZ看看，然后抓下snapshot看排序溢出情况 ...
wolaos123 发表于 2011-12-29 13:33

### BEGIN LOG - DATE: 111229, TIME: 174910 ###
db2 get db cfg for nchrb
   Database Configuration for Database nchrb
Database configuration release level                   = 0x0d00
Database release level                               = 0x0d00
Database territory                                     = CN
Database code page                                     = 1386
Database code set                                     = GBK
Database country/region code                         = 86
Database collating sequence                            = UNIQUE
Alternate collating sequence             (ALT_COLLATE) =
Number compatibility                                  = OFF
Varchar2 compatibility                               = OFF
Date compatibility                                     = OFF
Database page size                                     = 4096
Dynamic SQL Query management          (DYN_QUERY_MGMT) = DISABLE
Statement concentrator                   (STMT_CONC) = OFF
Discovery support for this database    (DISCOVER_DB) = ENABLE
Restrict access                                        = NO
Default query optimization class       (DFT_QUERYOPT) = 5
Degree of parallelism                   (DFT_DEGREE) = ANY
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age                (DFT_REFRESH_AGE) = 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained    (NUM_FREQVALUES) = 10
Number of quantiles retained          (NUM_QUANTILES) = 20
Decimal floating point rounding mode  (DECFLT_ROUNDING) = ROUND_HALF_EVEN
Backup pending                                        = NO
All committed transactions have been written to disk = NO
Rollforward pending                                  = NO
Restore pending                                        = NO
Multi-page file allocation enabled                   = YES
Log retain for recovery status                         = NO
User exit for logging status                         = YES
Self tuning memory                   (SELF_TUNING_MEM) = ON
Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC(1126558)
Database memory threshold             (DB_MEM_THRESH) = 10
Max storage for lock list (4KB)             (LOCKLIST) = 10240
Percent. of lock lists per application    (MAXLOCKS) = 80
Package cache size (4KB)                (PCKCACHESZ) = 20480
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(2897)
Sort list heap (4KB)                      (SORTHEAP) = AUTOMATIC(579)
Database heap (4KB)                         (DBHEAP) = 10240
Catalog cache size (4KB)             (CATALOGCACHE_SZ) = 3072
Log buffer size (4KB)                      (LOGBUFSZ) = 2048
Utilities heap size (4KB)             (UTIL_HEAP_SZ) = 415992
Buffer pool size (pages)                   (BUFFPAGE) = 1000
SQL statement heap (4KB)                   (STMTHEAP) = 4096
Default application heap (4KB)          (APPLHEAPSZ) = 6144
Application Memory Size (4KB)          (APPL_MEMORY) = AUTOMATIC(40000)
Statistics heap size (4KB)             (STAT_HEAP_SZ) = AUTOMATIC(4384)
Interval for checking deadlock (ms)       (DLCHKTIME) = 10000
Lock timeout (sec)                      (LOCKTIMEOUT) = 600
Changed pages threshold             (CHNGPGS_THRESH) = 80
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 1
Number of I/O servers                (NUM_IOSERVERS) = 1
Index sort flag                            (INDEXSORT) = YES
Sequential detect flag                   (SEQDETECT) = YES
Default prefetch size (pages)       (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages                      (TRACKMOD) = OFF
Default number of containers                         = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications          (MAXAPPLS) = 300
Average number of active applications    (AVG_APPLS) = 200
Max DB files open per application          (MAXFILOP) = 61440
Log file size (4KB)                      (LOGFILSIZ) = 51200
Number of primary log files             (LOGPRIMARY) = 15
Number of secondary log files             (LOGSECOND) = 100
Changed path to log files                (NEWLOGPATH) =
Path to log files                                     = /data/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Overflow log path                   (OVERFLOWLOGPATH) =
Mirror log path                      (MIRRORLOGPATH) =
First active log file                                  = S0000116.LOG
Block log on disk full             (BLK_LOG_DSK_FUL) = NO
Block non logged operations          (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction  (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Group commit count                         (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
Log retain for recovery enabled          (LOGRETAIN) = OFF
User exit for logging enabled             (USEREXIT) = OFF
HADR database role                                     = STANDARD
HADR local host name                (HADR_LOCAL_HOST) =
HADR local service name             (HADR_LOCAL_SVC) =
HADR remote host name             (HADR_REMOTE_HOST) =
HADR remote service name             (HADR_REMOTE_SVC) =
HADR instance name of remote server  (HADR_REMOTE_INST) =
HADR timeout value                      (HADR_TIMEOUT) = 120
HADR log write synchronization mode    (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0
First log archive method                (LOGARCHMETH1) = DISK:/data/archive/
Options for logarchmeth1                (LOGARCHOPT1) =
Second log archive method             (LOGARCHMETH2) = OFF
Options for logarchmeth2                (LOGARCHOPT2) =
Failover log archive path             (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs)       (ARCHRETRYDELAY) = 20
Vendor options                            (VENDOROPT) =
Auto restart enabled                   (AUTORESTART) = ON
Index re-creation time and redo index build  (INDEXREC) = SYSTEM (RESTART)
Log pages during index build          (LOGINDEXBUILD) = OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
Recovery history retention (days)    (REC_HIS_RETENTN) = 366
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF
TSM management class                   (TSM_MGMTCLASS) =
TSM node name                         (TSM_NODENAME) =
TSM owner                                  (TSM_OWNER) =
TSM password                            (TSM_PASSWORD) =
Automatic maintenance                   (AUTO_MAINT) = ON
Automatic database backup          (AUTO_DB_BACKUP) = OFF
Automatic table maintenance       (AUTO_TBL_MAINT) = ON
   Automatic runstats                (AUTO_RUNSTATS) = ON
   Automatic statement statistics  (AUTO_STMT_STATS) = ON
   Automatic statistics profiling (AUTO_STATS_PROF) = OFF
   Automatic profile updates       (AUTO_PROF_UPD) = OFF
   Automatic reorganization             (AUTO_REORG) = OFF
Auto-Revalidation                         (AUTO_REVAL) = DEFERRED
Currently Committed                      (CUR_COMMIT) = ON
CHAR output with DECIMAL input       (DEC_TO_CHAR_FMT) = NEW
Enable XML Character operations       (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes)    (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics                      (MON_REQ_METRICS) = BASE
Activity metrics                   (MON_ACT_METRICS) = BASE
Object metrics                      (MON_OBJ_METRICS) = BASE
Unit of work events                   (MON_UOW_DATA) = NONE
Lock timeout events                (MON_LOCKTIMEOUT) = NONE
Deadlock events                         (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events                      (MON_LOCKWAIT) = NONE
Lock wait event threshold             (MON_LW_THRESH) = 5000000
SMTP Server                            (SMTP_SERVER) =
$ db2 get db cfg for iufo
   Database Configuration for Database iufo
Database configuration release level                   = 0x0d00
Database release level                               = 0x0d00
Database territory                                     = CN
Database code page                                     = 1386
Database code set                                     = GBK
Database country/region code                         = 86
Database collating sequence                            = UNIQUE
Alternate collating sequence             (ALT_COLLATE) =
Number compatibility                                  = OFF
Varchar2 compatibility                               = OFF
Date compatibility                                     = OFF
Database page size                                     = 4096
Dynamic SQL Query management          (DYN_QUERY_MGMT) = DISABLE
Statement concentrator                   (STMT_CONC) = OFF
Discovery support for this database    (DISCOVER_DB) = ENABLE
Restrict access                                        = NO
Default query optimization class       (DFT_QUERYOPT) = 5
Degree of parallelism                   (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age                (DFT_REFRESH_AGE) = 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained    (NUM_FREQVALUES) = 10
Number of quantiles retained          (NUM_QUANTILES) = 20
Decimal floating point rounding mode  (DECFLT_ROUNDING) = ROUND_HALF_EVEN
Backup pending                                        = NO
All committed transactions have been written to disk = NO
Rollforward pending                                  = NO
Restore pending                                        = NO
Multi-page file allocation enabled                   = YES
Log retain for recovery status                         = NO
User exit for logging status                         = NO
Self tuning memory                   (SELF_TUNING_MEM) = ON
Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC(716160)
Database memory threshold             (DB_MEM_THRESH) = 10
Max storage for lock list (4KB)             (LOCKLIST) = 10240
Percent. of lock lists per application    (MAXLOCKS) = 80
Package cache size (4KB)                (PCKCACHESZ) = 20480
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(5000)
Sort list heap (4KB)                      (SORTHEAP) = AUTOMATIC(2000)
Database heap (4KB)                         (DBHEAP) = 10240
Catalog cache size (4KB)             (CATALOGCACHE_SZ) = 3072
Log buffer size (4KB)                      (LOGBUFSZ) = 2048
Utilities heap size (4KB)             (UTIL_HEAP_SZ) = 86704
Buffer pool size (pages)                   (BUFFPAGE) = 1000
SQL statement heap (4KB)                   (STMTHEAP) = 4096
Default application heap (4KB)          (APPLHEAPSZ) = 4000
Application Memory Size (4KB)          (APPL_MEMORY) = AUTOMATIC(40000)
Statistics heap size (4KB)             (STAT_HEAP_SZ) = AUTOMATIC(4384)
Interval for checking deadlock (ms)       (DLCHKTIME) = 10000
Lock timeout (sec)                      (LOCKTIMEOUT) = 600
Changed pages threshold             (CHNGPGS_THRESH) = 80
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 1
Number of I/O servers                (NUM_IOSERVERS) = 1
Index sort flag                            (INDEXSORT) = YES
Sequential detect flag                   (SEQDETECT) = YES
Default prefetch size (pages)       (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages                      (TRACKMOD) = OFF
Default number of containers                         = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications          (MAXAPPLS) = 300
Average number of active applications    (AVG_APPLS) = 200
Max DB files open per application          (MAXFILOP) = 61440
Log file size (4KB)                      (LOGFILSIZ) = 51200
Number of primary log files             (LOGPRIMARY) = 15
Number of secondary log files             (LOGSECOND) = 100
Changed path to log files                (NEWLOGPATH) =
Path to log files                                     = /data/iufo/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Overflow log path                   (OVERFLOWLOGPATH) =
Mirror log path                      (MIRRORLOGPATH) =
First active log file                                  =
Block log on disk full             (BLK_LOG_DSK_FUL) = NO
Block non logged operations          (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction  (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Group commit count                         (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
Log retain for recovery enabled          (LOGRETAIN) = OFF
User exit for logging enabled             (USEREXIT) = OFF
HADR database role                                     = STANDARD
HADR local host name                (HADR_LOCAL_HOST) =
HADR local service name             (HADR_LOCAL_SVC) =
HADR remote host name             (HADR_REMOTE_HOST) =
HADR remote service name             (HADR_REMOTE_SVC) =
HADR instance name of remote server  (HADR_REMOTE_INST) =
HADR timeout value                      (HADR_TIMEOUT) = 120
HADR log write synchronization mode    (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0
First log archive method                (LOGARCHMETH1) = OFF
Options for logarchmeth1                (LOGARCHOPT1) =
Second log archive method             (LOGARCHMETH2) = OFF
Options for logarchmeth2                (LOGARCHOPT2) =
Failover log archive path             (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs)       (ARCHRETRYDELAY) = 20
Vendor options                            (VENDOROPT) =
Auto restart enabled                   (AUTORESTART) = ON
Index re-creation time and redo index build  (INDEXREC) = SYSTEM (RESTART)
Log pages during index build          (LOGINDEXBUILD) = OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
Recovery history retention (days)    (REC_HIS_RETENTN) = 366
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF
TSM management class                   (TSM_MGMTCLASS) =
TSM node name                         (TSM_NODENAME) =
TSM owner                                  (TSM_OWNER) =
TSM password                            (TSM_PASSWORD) =
Automatic maintenance                   (AUTO_MAINT) = ON
Automatic database backup          (AUTO_DB_BACKUP) = OFF
Automatic table maintenance       (AUTO_TBL_MAINT) = ON
   Automatic runstats                (AUTO_RUNSTATS) = ON
   Automatic statement statistics  (AUTO_STMT_STATS) = ON
   Automatic statistics profiling (AUTO_STATS_PROF) = OFF
   Automatic profile updates       (AUTO_PROF_UPD) = OFF
   Automatic reorganization             (AUTO_REORG) = OFF
Auto-Revalidation                         (AUTO_REVAL) = DEFERRED
Currently Committed                      (CUR_COMMIT) = ON
CHAR output with DECIMAL input       (DEC_TO_CHAR_FMT) = NEW
Enable XML Character operations       (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes)    (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics                      (MON_REQ_METRICS) = BASE
Activity metrics                   (MON_ACT_METRICS) = BASE
Object metrics                      (MON_OBJ_METRICS) = BASE
Unit of work events                   (MON_UOW_DATA) = NONE
Lock timeout events                (MON_LOCKTIMEOUT) = NONE
Deadlock events                         (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events                      (MON_LOCKWAIT) = NONE
Lock wait event threshold             (MON_LW_THRESH) = 5000000
SMTP Server                            (SMTP_SERVER) =
$ exit
$ exit
# ls

银行 · 2011-12-30

B2 UDB, catalog services, sqlrl_userTempSubActions, probe:5551

查看其它 14 个回答top_vip 的回答

回答者

top_vip 最近回答过的问题

回答状态