DB2不能啟動(dòng)了，求大俠！

iloveyou_parent

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.

windwiny

啟動(dòng)時(shí)應(yīng)該有 sqlXXXX的錯(cuò)誤，用 db2 ? sqlxxxx 查詢

Star約會(huì)

求解

iceTouch

啟動(dòng)時(shí)報(bào)的錯(cuò)誤貼出來(lái)

znvmbc

[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