论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2007-02-05 11:52 |只看该作者 |倒序浏览

db2出现错误，日志信息如下，请各位帮忙看看，多谢。

FUNCTION: DB2 UDB, SQO Memory Management, sqlofmblkEx, probe: 20

MESSAGE: DiagData

DATA #1 : Hexdump, 4 bytes

0x0FFFFFFFFFFF58C0: 820F 0002

文库|博客

大梦

版主

论坛徽章:: 11

2楼 [报告]

发表于 2007-02-05 12:43 |只看该作者

这个信息太少了!
把db2diag.log的内容再多贴点!
看看下面链接,有没有帮助!

http://www-1.ibm.com/support/docview.wss?uid=swg1IY51630

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

beginner-bj

大富大贵

论坛徽章:: 1

3楼 [报告]

发表于 2007-02-05 13:12 |只看该作者

SQL0083C内存分配出错。

解释:

在处理中，内存不足以继续处理。

用户响应:

可能的解决方案包括：

o 确保系统有足够的实际内存或虚拟内存。

o 除去后台进程。

如果在尝试建议的解决方案后仍然接收到此消息，则与“IBM
客户支持机构”联系。

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

china2006unix

白手起家

论坛徽章:: 0

4楼 [报告]

发表于 2007-02-05 14:36 |只看该作者

回复 2楼大梦的帖子

详细点的信息，请版主指教。
2007-02-05-00.00.55.608699+480 I965974A411       LEVEL: Severe
PID    : 4612200             TID  : 1          PROC : db2agent (instance) 0
INSTANCE: sjck             NODE : 000
APPHDL  : 0-535             APPID: P624227C.IC08.017344160212
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
      "External Comm error"

2007-02-05-00.15.55.917622+480 I1075729A411    LEVEL: Severe
PID    : 11604158          TID  : 1          PROC : db2agent (instance) 0
INSTANCE: sjck             NODE : 000
APPHDL  : 0-486             APPID: P624227C.L008.017344161712
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
      "External Comm error"

2007-02-05-02.27.25.791331+480 I1080843A360    LEVEL: Severe
PID    : 12800122          TID  : 1          PROC : db2agent (idle) 0
INSTANCE: sjck             NODE : 000
FUNCTION: DB2 UDB, SQO Memory Management, sqlofmblkEx, probe:20
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFF58C0 : 820F 0002                               ....

2007-02-05-02.27.25.791778+480 I1081204A364    LEVEL: Severe
PID    : 12800122          TID  : 1          PROC : db2agent (idle) 0
INSTANCE: sjck             NODE : 000
FUNCTION: DB2 UDB, SQO Memory Management, sqlofmblkEx, probe:21
MESSAGE : DiagData
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFF5A60 : 0000 0001 11E4 A080                      ........

2007-02-05-02.27.25.791948+480 I1081569A454    LEVEL: Severe
PID    : 12800122          TID  : 1          PROC : db2agent (idle) 0
INSTANCE: sjck             NODE : 000
FUNCTION: DB2 UDB, SQO Memory Management, sqlofmblkEx, probe:22
MESSAGE : DiagData
DATA #1 : Hexdump, 32 bytes
0x0000000111E4A070 : 3332 3330 3200 0002 3636 0000 0130 0000 32302...66...0..
0x0000000111E4A080 : 000A D041 0001 0004 200F 000A D005 0002 ...A.... .......

2007-02-05-02.27.25.862606+480 I1082024A173    LEVEL: Severe
PID:12800122 TID:1 NODE:000 Title: SQLE_AGENTCB
Dump File:/software/db2/sjck/sqllib/db2dump/128001221.000

2007-02-05-02.27.25.889305+480 I1082198A181    LEVEL: Severe
PID:12800122 TID:1 NODE:000 Title: SQLE_AGENT_PRIVATECB
Dump File:/software/db2/sjck/sqllib/db2dump/128001221.000

2007-02-05-02.27.25.889449+480 I1082380A374    LEVEL: Severe
PID    : 12800122          TID  : 1          PROC : db2agent (idle) 0
INSTANCE: sjck             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x07800000000081CC : 0000 0000                               ....

2007-02-05-02.27.25.993103+480 E1082755A519    LEVEL: Severe
PID    : 12800122          TID  : 1          PROC : db2agent (idle) 0
INSTANCE: sjck             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503C  An unexpected internal processing error has occurred.  ALL
      DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
      Diagnostic information has been recorded.  Contact IBM Support for
      further assistance.

2007-02-05-02.27.25.993810+480 E1083275A651    LEVEL: Severe
PID    : 12800122          TID  : 1          PROC : db2agent (idle) 0
INSTANCE: sjck             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
6
DATA #2 : Siginfo, 64 bytes
0x0FFFFFFFFFFF4A80 : 0000 0006 0000 0000 0000 0009 0000 0000 ................
0x0FFFFFFFFFFF4A90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4AA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4AB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2007-02-05-02.27.25.994002+480 I1083927A173    LEVEL: Severe
PID:12800122 TID:1 NODE:000 Title: SQLE_AGENTCB
Dump File:/software/db2/sjck/sqllib/db2dump/128001221.000

2007-02-05-02.27.25.994126+480 I1084101A181    LEVEL: Severe
PID:12800122 TID:1 NODE:000 Title: SQLE_AGENT_PRIVATECB
Dump File:/software/db2/sjck/sqllib/db2dump/128001221.000

2007-02-05-02.27.26.129956+480 I1084283A438    LEVEL: Severe
PID    : 2199568             TID  : 1          PROC : db2tcpcm 0
INSTANCE: sjck             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUSIGCHLDHandler, probe:50
DATA #1 : String, 163 bytes
Detected the death of an EDU with process id 12800122
The signal number that terminated this process was 6
Look for trap files (t12800122.*) in the dump directory

2007-02-05-02.27.26.211704+480 E1084722A512    LEVEL: Severe
PID    : 2199568             TID  : 1          PROC : db2tcpcm 0
INSTANCE: sjck             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503C  An unexpected internal processing error has occurred.  ALL
      DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
      Diagnostic information has been recorded.  Contact IBM Support for
      further assistance.