DEPLETION OF QUEUE SHARED MEMORY CAUSES DB2 TO ABEND (PANIC) ON WINDOWS

字数 12901阅读 4792评论 0赞 0

<DIV>
2013<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">年11<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">月12<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">日，晚上收到报警信息，于23<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">点55<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">分的时候登录到数据库服务器查看日志，数据库版本是NT64<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">位 V9.5FP8<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">：
2013-11-12-20.03.36.703000+480 I165895F562        LEVEL: Error
PID     : 6036                 TID  : 764         PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : XXXX
APPHDL  : 0-36672              APPID: 192.168.100.5.22281.13111120121
AUTHID  : DB2ADMIN
EDUID   : 764                  EDUNAME: db2agent (WZHDB2)
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 121 bytes
LOADID: 764.2013-11-12-20.02.43.062002.0 (2;6936)
 , -2029060031, 0000000000000000, Detected in file:sqluvld.C, Line:8024
 
2013-11-12-20.03.36.703000+480 I166459F1035       LEVEL: Error
PID     : 6036                 TID  : 764         PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : XXXX
APPHDL  : 0-36672              APPID: 192.168.100.5.22281.13111120121
AUTHID  : DB2ADMIN
EDUID   : 764                  EDUNAME: db2agent (WZHDB2)
FUNCTION: DB2 UDB, database utilities, sqlulSndEndMsg, probe:8027
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
          "SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 764.2013-11-12-20.02.43.062002.0 (2;6936)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2044   sqlerrml: 1
 sqlerrmc: 3
 sqlerrp : SQLUVLD 
 sqlerrd : (1) 0x8015006D      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)    
           (7)      (8)      (9)      (10)        (11)     
 sqlstate:      
 
2013-11-12-20.03.36.718000+480 I167496F471        LEVEL: Error
PID     : 6036                 TID  : 5360        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
EDUID   : 5360                 EDUNAME: db2lbm2
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 153 bytes
LOADID: 764.2013-11-12-20.02.43.062002.0 (2;6936)
Error writing message to queue. , -2029060031, 0000000000000003, Detected in file:sqluvld.C, Line:16827
 
2013-11-12-20.03.36.718000+480 I167969F516        LEVEL: Severe
PID     : 6036                 TID  : 764         PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : XXXX
APPHDL  : 0-36672              APPID: 192.168.100.5.22281.13111120121
AUTHID  : DB2ADMIN
EDUID   : 764                  EDUNAME: db2agent (WZHDB2)
FUNCTION: DB2 UDB, database utilities, sqlulSndEndMsg, probe:8027
MESSAGE : DIA0001E An internal error occurred. Report the following error code
 
<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">发现从20<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">：03<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的时候数据库在做load<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">操作的时候发生异常。并将错误信心发送给message queue<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">中。
 
 
2013-11-12-20.14.53.343000+480 I389071F597        LEVEL: Error
PID     : 6036                 TID  : 764         PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : XXXX
APPHDL  : 0-36672              APPID: 192.168.100.5.22281.13111120121
AUTHID  : DB2ADMIN
EDUID   : 764                  EDUNAME: db2agent (WZHDB2)
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 156 bytes
LOADID: 764.2013-11-12-20.14.53.343000.0 (2;6936)
Failed to lock table and fix TCB , -2147221458, 0000000000000000, Detected in file:sqluTarget.C, Line:3025
 
2013-11-12-20.14.53.343000+480 I389670F491        LEVEL: Severe
PID     : 6036                 TID  : 764         PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : XXXX
APPHDL  : 0-36672              APPID: 192.168.100.5.22281.13111120121
AUTHID  : DB2ADMIN
EDUID   : 764                  EDUNAME: db2agent (WZHDB2)
FUNCTION: DB2 UDB, database utilities, sqluRegisterLoadStart, probe:2436
MESSAGE : Load Error: Attempt to lock table/fix tcb unsuccessful
 
2013-11-12-20.14.53.343000+480 I390163F465        LEVEL: Severe
PID     : 6036                 TID  : 764         PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : XXXX
APPHDL  : 0-36672              APPID: 192.168.100.5.22281.13111120121
AUTHID  : DB2ADMIN
EDUID   : 764                  EDUNAME: db2agent (WZHDB2)
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:3568
MESSAGE : Load Error: Error loading table.
 
2013-11-12-20.14.53.343000+480 I390630F598        LEVEL: Error
PID     : 6036                 TID  : 764         PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : XXXX
APPHDL  : 0-36672              APPID: 192.168.100.5.22281.13111120121
AUTHID  : DB2ADMIN
EDUID   : 764                  EDUNAME: db2agent (WZHDB2)
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 157 bytes
LOADID: 764.2013-11-12-20.14.53.343000.0 (2;6936)
Error acquiring partition resources. , -2147221458, 0000000000000000, Detected in file:sqluvtld.C, Line:921
 
2013-11-12-20.14.53.343000+480 I391230F468        LEVEL: Warning
PID     : 6036                 TID  : 764         PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : XXXX
APPHDL  : 0-36672              APPID: 192.168.100.5.22281.13111120121
AUTHID  : DB2ADMIN
EDUID   : 764                  EDUNAME: db2agent (WZHDB2)
FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:100
MESSAGE : SQLEU_FLAG1_FORCE_RBK is set, doing rollback
 
<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">在后续日志中查看到由于第一次的load<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">失败导致后续的重启load<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">操作由于无法锁定，从而报错。
 
2013-11-13-00.20.35.937000+480 I897148F442        LEVEL: Severe
PID     : 6036                 TID  : 3660        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
EDUID   : 3660                 EDUNAME: db2ipccm
FUNCTION: DB2 UDB, common communication, sqlccipc_process_conn, probe:1
RETCODE : ZRC=0x870F0041=-2029060031=SQLO_QUE_NOT_SENT "Message Not Sent"
          DIA8557C No message was sent using the message queue.
2013-11-13-00.20.35.953000+480 E898846F807        LEVEL: Critical
PID     : 6036                 TID  : 3660        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
EDUID   : 3660                 EDUNAME: db2ipccm
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : ADM14001C  An unexpected and critical error has occurred: "Panic". 
          The instance may have been shutdown as a result. "Automatic" FODC 
          (First Occurrence Data Capture) has been invoked and diagnostic 
          information has been recorded in directory 
          "X:DB2PROFSDB2FODC_Panic_2013-11-13-00.20.35.953000". Please look 
          in this directory for detailed evidence about what happened and 
          contact IBM support if necessary to diagnose the problem.
 
<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">在13<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">日00<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">：20<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">时抛出异常，数据库无法获得message queue<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">从而导致数据库down<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">机。
db2ipccm<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">管理数据库的本地连接，netstat<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">的时候发生机器上的tcp<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">连接丢失。
http://www-01.ibm.com/support/docview.wss?uid=swg1IC69885
<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">由于数据库load<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">操作发生异常，进行load<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">抛出的错误消息过多，导致message queue memory<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">不足导致数据库实例down<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">掉。
<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">由于该库已经是9.5fp8<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">版本，大于IBM<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">发出的fp7<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">补丁，因此修改程序指定load CPU_PARALLELISM<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">为1<SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">，db2set DB2NTMEMSIZE=QUE:67108864<SPAN style="FONT-FAMILY: 宋体; COLOR: #333333; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin">扩大消息队列来避免该问题。</DIV>

Db2 数据库

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

DEPLETION OF QUEUE SHARED MEMORY CAUSES DB2 TO ABEND (PANIC) ON WINDOWS

添加新评论0 条评论

作者其他文章

相关文章

相关问题

相关资料