DB2不能启动了,求大侠!
本帖最后由 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_servicessqlbFreeUpSlot 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_servicessqlbGetVictimSlot 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_servicessqlbGetVictimSlot 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_servicessqlbFreeUpSlot 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_servicessqlbGetVictimSlot 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_servicessqlbGetVictimSlot 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_servicessqlbFreeUpSlot 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_servicessqlbGetVictimSlot 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_servicessqlbFreeUpSlot 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_servicessqlbGetVictimSlot 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_servicessqlbGetVictimSlot 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_servicessqlbGetVictimSlot 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_servicessqlbGetVictimSlot 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_protectiondb2ArchiveLog Probe:80
Failed to connect to database. 启动时应该有 sqlXXXX的错误,用 db2 ? sqlxxxx 查询 求解 启动时报的错误贴出来 本帖最后由 znvmbc 于 2012-03-23 11:40 编辑
$ db2diag -rc 0xFFFFD12C
Input ECF string '0xFFFFD12C' parsed as 0xFFFFD12C (-11988).
NOTE: /view/db2_v97fp5_linuxia32_s111017/vbs/engn/pd/../sqz/sqlzwhatisrc.C:
V7 input ZRC 0xFFFFD12C (-11988) may translate to V8 ZRC value of 0x8502002C (-2063466452)
ZRC value to map: 0x8502002C (-2063466452)
V7 Equivalent ZRC value: 0xFFFFD12C (-11988)
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
SQL1218NThere are no pages currently available in bufferpool "".
Number of sqlca tokens : 1
Diaglog message number: 1
=================
$ db2 ? SQL1218N
SQL1218NThere 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
页:
[1]