最近经常出现这个问题,不知道为什么会去用IBMSYSTEMBP4K 这个隐藏的缓冲池,下面是自己创建的缓冲池和出现问题时附近的日志,大家帮忙分析下
IBMDEFAULTBP 1 (null) 102400 4096 N 0 0 (null)
BP8K 2 (null) 25600 8192 N 0 0 (null)
BP16K 3 (null) 24576 16384 N 0 0 (null)
2012-12-07-19.06.18.591869+480 E130561924G789 LEVEL: Error (OS)
PID : 27170 TID : 3023240080 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 36 bytes
0xB4325F7C : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
0xB4325F8C : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
0xB4325F9C : 7069 7065 pipe
DATA #4 : File name, 34 bytes
/home/dasusr1/das/tmp/dasnamedpipe
2012-12-07-19.07.18.695455+480 E130562714G789 LEVEL: Error (OS)
PID : 27170 TID : 3023240080 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 36 bytes
0xB4325F7C : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
0xB4325F8C : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
0xB4325F9C : 7069 7065 pipe
DATA #4 : File name, 34 bytes
/home/dasusr1/das/tmp/dasnamedpipe
2012-12-07-19.12.18.870194+480 E130563504G789 LEVEL: Error (OS)
PID : 27170 TID : 3023240080 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 36 bytes
0xB4325F7C : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
0xB4325F8C : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
0xB4325F9C : 7069 7065 pipe
DATA #4 : File name, 34 bytes
/home/dasusr1/das/tmp/dasnamedpipe
2012-12-07-19.12.21.554186+480 E130564294G423 LEVEL: Warning
PID : 27170 TID : 3001342864 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10502W Health indicator "Database Backup Required"
("db.db_backup_req") is in state "Manual backup required" on
"database" "db2inst1.DYJXKH ".
2012-12-07-19.17.18.089229+480 E130564718G789 LEVEL: Error (OS)
PID : 27170 TID : 3023240080 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 36 bytes
0xB4325F7C : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
0xB4325F8C : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
0xB4325F9C : 7069 7065 pipe
DATA #4 : File name, 34 bytes
/home/dasusr1/das/tmp/dasnamedpipe
2012-12-07-19.18.18.170933+480 E130565508G789 LEVEL: Error (OS)
PID : 27170 TID : 3023240080 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
DATA #1 : String, 32 bytes
Unable to connect socket on path
DATA #2 : socket, 4 bytes
6
DATA #3 : sockaddr, 36 bytes
0xB4325F7C : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
0xB4325F8C : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
0xB4325F9C : 7069 7065 pipe
DATA #4 : File name, 34 bytes
/home/dasusr1/das/tmp/dasnamedpipe
2012-12-07-19.18.46.050706+480 E130566298G546 LEVEL: Error
PID : 27158 TID : 3056593808 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DYJXKH
APPHDL : 0-251 APPID: *LOCAL.db2inst1.121207092309
AUTHID : DYBANK
EDUID : 833 EDUNAME: db2agent (DYJXKH) 0
FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:122
MESSAGE : ADM6019E All pages in buffer pool "IBMSYSTEMBP4K" (ID "4096") are in
use. Refer to the documentation for SQLCODE -1218.
附件:
db_cfg.txt (7.12 KB)
dbm_cfg.txt (5.09 KB)