Hello,

I am getting the following error in db2diag.log and my database has become very slow.

ADM6019E All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in use.
Refer to the documentation for SQLCODE -1218.

Can anyone help me on this??

Look higher in you db2diag and you'll see that some bufferpools could not be allocated.
Can only be solved with an instance-restart. If problem persists you'll have to check&correct your memory settings.

As dr_te_Z said,

Look for something similar to

and you may also find similar to this one

Its a memory issue

DBFinder

Hi,

In the db2daig.log following message has occured many times.

2009-06-11-13.28.57.578000 InstanceB2 Node:000
PID:6184(db2syscs.exe) TID:5636 Appid:none
buffer pool services sqlbFreeUpSlot Probe:122

ADM6019E All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in use.
Refer to the documentation for SQLCODE -1218.

PID:6184 TID:5636 Node:000 Title: (NULL)
Could not fix page for objID=67, tbspaceID=2, objType=1, parentObjID=67 parentTbspaceID=2.


PID:6184 TID:5636 Node:000 Title: (NULL)
Current size of bufferpool #4096: 16 slots.


2009-06-11-13.28.57.765000 InstanceB2 Node:000
PID:6184(db2syscs.exe) TID:5636 Appid:none
buffer pool services sqlbErrorHandler Probe:0

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8502002C".

2009-06-11-13.28.57.828000 InstanceB2 Node:000
PID:6184(db2syscs.exe) TID:5636 Appid:none
buffer pool services sqlbErrorHandler Probe:0

Obj={pool:2;obj:67;type:1} State=x27
Prefetcher Error, in sqlbServiceListRequest

PID:6184 TID:5636 Node:000 Title: SQLB_OBJECT_DESC
0x04BE906C : 0200 4300 0200 4300 0100 0000 0038 566B ..C...C......8Vk
0x04BE907C : 6530 0000 0000 0000 0000 0000 0000 0000 e0..............
0x04BE908C : 0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0x04BE909C : 0010 0000 2000 0000 0010 0000 0200 4301 .... .........C.
0x04BE90AC : F0EB 8106 ..


I tried restarting the instance also, but it didnt help.

We got to that point, right?
You did not mention your version, so I'll assume the-latest-and-the greatest version.
The 1st thing I would try and re-start your database.
IF that works AND you've got STMM enabled
THEN do not worry about the underallocated bufferpools
ELSE bring your bufferpools back on requred size by means of the "alter bufferpool" command .

The database was started using hidden bufferpools because there was not enough memory to allocate the real bufferpool(s). The hidden bufferpools are very small (16 pages - one for each page size) and that's why you got the error. What you need to do is to reduce the size of your real bufferpool(s) so that the db can be started successfully (you will receive sql1478w when the db is started using hidden bufferpools)

Thanx all of you..

I got the why this problem was coming and now its gone..
Some of the database files got written to some other folder including the files containing the bufferpool information.
So the database was not able to find the bufferpool info and hence was getting started using the hidden BP.

I copied the files back to the correct location and now it is working properly.

Hello,

i have a very similar problem. Here are the facts out of the db2diag.log
I don´t know, which bufferpools i have to change.

2009-09-10-09.31.36.484000+120 E16472H557 LEVEL: Error
PID : 2264 TID : 3072 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : RMDB
APPHDL : 0-2793 APPID: 10.200.75.107.18081.09091007083
AUTHID : RMADMIN
EDUID : 3072 EDUNAME: db2agent (RMDB) 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.

2009-09-10-09.31.36.656000+120 I17031H528 LEVEL: Severe
PID : 2264 TID : 3072 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : RMDB
APPHDL : 0-2793 APPID: 10.200.75.107.18081.09091007083
AUTHID : RMADMIN
EDUID : 3072 EDUNAME: db2agent (RMDB) 0
FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:0
DATA #1 : String, 89 bytes
Could not fix page for objID=3, tbspaceID=8, objType=1, parentObjID=3 parentTbspaceID=8.

2009-09-10-09.31.36.656000+120 I17561H483 LEVEL: Severe
PID : 2264 TID : 3072 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : RMDB
APPHDL : 0-2793 APPID: 10.200.75.107.18081.09091007083
AUTHID : RMADMIN
EDUID : 3072 EDUNAME: db2agent (RMDB) 0
FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:0
DATA #1 : String, 44 bytes
Current size of bufferpool #4096: 16 slots.

2009-09-10-09.31.36.656000+120 I18046H497 LEVEL: Severe
PID : 2264 TID : 3072 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : RMDB
APPHDL : 0-2793 APPID: 10.200.75.107.18081.09091007083
AUTHID : RMADMIN
EDUID : 3072 EDUNAME: db2agent (RMDB) 0
FUNCTION: DB2 UDB, index manager, sqlifix, probe:371
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

Yep, same problem. This can never be solved without stop/start of the database. Just before you come the that, issue a "db2diag -A" command so you'll get a fresh copy of your db2diag.log file. This will make it easier. So when you start you database again watch the diaglog closely to see which bufferpool cannot be allocated. Good luck.

You have tablespace ID as tbspaceID=8.
Find out which bufferpool is it using. That's the one.

Restarting and watching diaglog is a confirmation and will most probably point to same thing.

DBFinder

IBMSYSTEMBP4K is one of the hidden/system bufferpools. Most likely, there was not enough memory to allocate the real bufferpool(s) so the db is using hidden bufferpools. Hidden bufferpools are very small and so it's very easy to get -1218.