免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3125 | 回复: 2
打印 上一主题 下一主题

数据库一连接,实例就crash,一个朋友的问题,帮忙看看 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2006-09-27 23:00 |只看该作者 |倒序浏览
$ mv db2diag.log db2diag_20060927.log
$ db2start
09/27/2006 11:19:34 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
$ tail -200 db2diag.log

2006-09-27-11.19.33.399660 Instance:db2inst2 Node:000
PID:1138906(db2star2) TID:1 Appid:none
base sys utilities LicCheckProcessors Probe:20

SQL8017W The number of processors on this machine exceeds the defined
entitlement of "1" for the product "DB2 Enterprise Server Edition". The
number of processors on this machine is "6". You should purchase additional
processor based entitlements from your IBM representative or authorized dealer
and update your license using the License Center or the db2licm command line
utility. For more information on updating processor based licenses, refer to
the Quick Beginnings manual for your platform. For more information on the
db2licm utility, refer to the DB2 Command Reference.


2006-09-27-11.19.34.588939 Instance:db2inst2 Node:000
PID:532610(db2spmrsy 0) TID:1 Appid:none
oper system services sqloopenp Probe:60

errno:
0x2FF1C7E0 : 0x00000011 ....

PID:532610 TID:1 Node:000 Title: Path/Filename
/mqha/db2ha/db2inst2/sqllib/spmlog/SPMLOG.LCF

2006-09-27-11.19.34.605985 Instance:db2inst2 Node:000
PID:1138906(db2star2) TID:1 Appid:none
base sys utilities DB2StartMain Probe:911

ADM7513W Database manager has started.
然后 $ db2 connect to icmnlsdb
SQL1032N No start database manager command was issued. SQLSTATE=57019
在db2inst2.nfy 中2006-09-27-11.25.36.327575 Instance:db2inst2 Node:000
PID:999498(db2star2) TID:1 Appid:none
base sys utilities DB2StartMain Probe:911

ADM7513W Database manager has started.

2006-09-27-11.26.05.034846 Instance:db2inst2 Node:000
PID:1179846(db2agent (RMDB) 0) TID:1 Appid:*LOCAL.db2inst2.060777032604
recovery manager sqlpresr Probe:410 Database:RMDB

ADM1530E Crash recovery has been initiated.

2006-09-27-11.26.05.164135 Instance:db2inst2 Node:000
PID:1179846(db2agent (RMDB) 0) TID:1 Appid:*LOCAL.db2inst2.060777032604
recovery manager sqlpresr Probe:3170 Database:RMDB

ADM1531E Crash recovery has completed successfully


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.

2006-09-27-11.27.38.658264 Instance:db2inst2 Node:000
PID:991392(db2wdog 0 0) TID:1 Appid:none
oper system services sqloRunInstance Probe:500

DiagData
0x2FF21B18 : 0x0000010200000009 ........

2006-09-27-11.27.38.664256 Instance:db2inst2 Node:000
PID:991392(db2wdog 0 0) TID:1 Appid:none
base sys utilities sqleCleanupResources Probe:5

DiagData
0x2FF21A98 : 0x00000102 ....

2006-09-27-11.27.39.233478 Instance:db2inst2 Node:000
PID:434384(db2ckpwd 0) TID:1 Appid:none
oper system services sqlockpw_daemon_main Probe:50

0x2FF21510 : 0x870F0042 ...B

2006-09-27-11.27.39.233499 Instance:db2inst2 Node:000
PID:491772(db2ckpwd 0) TID:1 Appid:none
oper system services sqlockpw_daemon_main Probe:50

0x2FF21510 : 0x870F0042 ...B

2006-09-27-11.27.39.233497 Instance:db2inst2 Node:000
PID:766152(db2ckpwd 0) TID:1 Appid:none
oper system services sqlockpw_daemon_main Probe:50

0x2FF21510 : 0x870F0042

论坛徽章:
0
2 [报告]
发表于 2006-09-27 23:02 |只看该作者
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.

2006-09-27-15.01.00.155209 Instance:db2inst2 Node:000
PID:1028326(db2gds 0) TID:1 Appid:none
oper system services sqloEDUCodeTrapHandler Probe:20

Signal number received

0x2FF20D28 : 0x00000006 ....

PID:1028326 TID:1 Node:000 Title: siginfo_t...

0x2FF21010 : 0000 0006 0000 0000 0000 0009 0000 0000 ................
0x2FF21020 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF21030 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x2FF21040 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2006-09-27-15.01.00.193515 Instance:db2inst2 Node:000
PID:1118346(db2sysc 0) TID:1 Appid:none
base sys utilities sqleChildCrashHandler Probe:15

DiagData
0x10008A8C : 416E 2045 4455 2063 7261 7368 6564 2E An EDU crashed.

2006-09-27-15.01.00.197263 Instance:db2inst2 Node:000
PID:1118346(db2sysc 0) TID:1 Appid:none
base sys utilities sqleChildCrashHandler Probe:16

DiagData
0x2FF21234 : 0x000FB0E6 ..版

2006-09-27-15.01.00.200793 Instance:db2inst2 Node:000
PID:1118346(db2sysc 0) TID:1 Appid:none
base sys utilities sqleChildCrashHandler Probe:17

DiagData
0x2FF21238 : 0x00000101 ....

2006-09-27-15.01.00.204309 Instance:db2inst2 Node:000
PID:1118346(db2sysc 0) TID:1 Appid:none
base sys utilities sqleChildCrashHandler Probe:18

DiagData
0x2FF2123C : 0xFFFFFFFF

论坛徽章:
0
3 [报告]
发表于 2006-09-29 12:09 |只看该作者
操作系统是linux吗,可能需要修改内核参数
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP