免费注册 查看新帖 |

Chinaunix

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

DB2不能启动了,求大侠! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2012-02-27 13:08 |只看该作者 |倒序浏览
本帖最后由 iloveyou_parent 于 2012-02-27 13:09 编辑



String Title: PID:30444 Node:000
Could not fix page for objID=14866, tbspaceID=4, objType=0, parentObjID=14866 parentTbspaceID=4.

2012-02-27-10.34.16.510131   Instance:db2gda   Node:000
PID:30960(db2pfchr)   Appid:none
buffer_pool_services  sqlbFreeUpSlot   Probe:122

All pages in buffer pool 1 are in use.

2012-02-27-10.34.16.516568   Instance:db2gda   Node:000
PID:31734(db2pfchr)   Appid:none
buffer_pool_services  sqlbGetVictimSlot   Probe:727
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD12C".

2012-02-27-10.34.16.943100   Instance:db2gda   Node:000
PID:29154(db2pfchr)   Appid:none
buffer_pool_services  sqlbGetVictimSlot   Probe:727
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD12C".

2012-02-27-10.34.17.008665   Instance:db2gda   Node:000
PID:28380(db2pfchr)   Appid:none
buffer_pool_services  sqlbFreeUpSlot   Probe:122

All pages in buffer pool 1 are in use.

2012-02-27-10.34.17.014606   Instance:db2gda   Node:000
PID:30444(db2pfchr)   Appid:none
buffer_pool_services  sqlbGetVictimSlot   Probe:727
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD12C".

String Title: PID:30960 Node:000
Could not fix page for objID=14866, tbspaceID=4, objType=0, parentObjID=14866 parentTbspaceID=4.

2012-02-27-10.34.17.018270   Instance:db2gda   Node:000
PID:30960(db2pfchr)   Appid:none
buffer_pool_services  sqlbGetVictimSlot   Probe:727
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD12C".

2012-02-27-10.34.17.443290   Instance:db2gda   Node:000
PID:31218(db2pfchr)   Appid:none
buffer_pool_services  sqlbFreeUpSlot   Probe:122

All pages in buffer pool 1 are in use.

String Title: PID:31218 Node:000
Could not fix page for objID=14866, tbspaceID=4, objType=0, parentObjID=14866 parentTbspaceID=4.

2012-02-27-10.34.17.451034   Instance:db2gda   Node:000
PID:31218(db2pfchr)   Appid:none
buffer_pool_services  sqlbGetVictimSlot   Probe:727
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD12C".

2012-02-27-10.34.17.508813   Instance:db2gda   Node:000
PID:30702(db2pfchr)   Appid:none
buffer_pool_services  sqlbFreeUpSlot   Probe:122

All pages in buffer pool 1 are in use.

String Title: PID:30702 Node:000
Could not fix page for objID=14866, tbspaceID=4, objType=0, parentObjID=14866 parentTbspaceID=4.

String Title: PID:28380 Node:000
Could not fix page for objID=14866, tbspaceID=4, objType=0, parentObjID=14866 parentTbspaceID=4.

2012-02-27-10.34.17.517588   Instance:db2gda   Node:000
PID:30702(db2pfchr)   Appid:none
buffer_pool_services  sqlbGetVictimSlot   Probe:727
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD12C".

String Title: PID:31992 Node:000
Could not fix page for objID=14866, tbspaceID=4, objType=0, parentObjID=14866 parentTbspaceID=4.

2012-02-27-10.34.17.945069   Instance:db2gda   Node:000
PID:31992(db2pfchr)   Appid:none
buffer_pool_services  sqlbGetVictimSlot   Probe:727
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD12C".

String Title: PID:27606 Node:000
Could not fix page for objID=14866, tbspaceID=4, objType=0, parentObjID=14866 parentTbspaceID=4.

2012-02-27-10.34.18.010376   Instance:db2gda   Node:000
PID:27606(db2pfchr)   Appid:none
buffer_pool_services  sqlbGetVictimSlot   Probe:727
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD12C".

2012-02-27-10.34.18.017710   Instance:db2gda   Node:000
PID:28380(db2pfchr)   Appid:none
buffer_pool_services  sqlbGetVictimSlot   Probe:727
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD12C".

2012-02-27-11.17.27.274266   Instance:db2gda   Node:000
PID:41542(db2bp)   Appid:
data_protection  db2ArchiveLog   Probe:80

Failed to connect to database.

db2diag.zip

86.72 KB, 下载次数: 15

日志

论坛徽章:
0
2 [报告]
发表于 2012-02-28 10:04 |只看该作者
启动时应该有 sqlXXXX的错误,用 db2 ? sqlxxxx 查询

论坛徽章:
0
3 [报告]
发表于 2012-02-29 13:50 |只看该作者
求解

论坛徽章:
0
4 [报告]
发表于 2012-03-16 16:58 |只看该作者
启动时报的错误贴出来

论坛徽章:
0
5 [报告]
发表于 2012-03-23 11:39 |只看该作者
本帖最后由 znvmbc 于 2012-03-23 11:40 编辑

[db2admin@localhost ~]$ db2diag -rc 0xFFFFD12C

Input ECF string '0xFFFFD12C' parsed as 0xFFFFD12C (-1198.
NOTE: /view/db2_v97fp5_linuxia32_s111017/vbs/engn/pd/../sqz/sqlzwhatisrc.C:
        V7 input ZRC 0xFFFFD12C (-1198 may translate to V8 ZRC value of 0x8502002C (-2063466452)

ZRC value to map: 0x8502002C (-2063466452)
        V7 Equivalent ZRC value: 0xFFFFD12C (-1198

ZRC class :
        Resource Capacity Error (Class Index: 5)
Component:
        SQLB ; buffer pool services (Component Index: 2)
Reason Code:
        44 (0x002C)

Identifer:
        SQLB_BPFULL
Identifer (without component):
        SQLZ_RC_BPFULL

Description:
        no available buffer pool pages

Associated information:
        Sqlcode -1218
SQL1218N  There are no pages currently available in bufferpool "".

        Number of sqlca tokens : 1
        Diaglog message number: 1



=================
[db2admin@localhost ~]$ db2 ? SQL1218N


SQL1218N  There are no pages currently available in bufferpool
      "<buffpool-num>".

Explanation:

All of the pages in the bufferpool are currently being used. A request
to use another page failed.

The statement cannot be processed.

User response:

The bufferpool is not large enough to provide pages to all database
processes or threads at this time. The bufferpool is too small or there
are too many active processes or threads.

The statement may be successful if executed again. If this error occurs
frequently, some or all of the following actions may prevent further
failures:
1. increase the bufferpool size
2. decrease the maximum number of database agents and/or connections
3. decrease the maximum degree of parallelism
4. decrease the prefetch size for table spaces that are in this
   bufferpool
5. move some table spaces into other bufferpools.

sqlcode: -1218

sqlstate: 57011

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP