Results 1 to 11 of 11
  1. #1
    Join Date
    Mar 2009
    Posts
    16

    Unanswered: Bufferpool Error

    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??

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    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.

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    As dr_te_Z said,

    Look for something similar to

    MESSAGE : ADM6073W The table space "SYSCATSPACE" (ID "0") is configured to use
    buffer pool ID "1", but this buffer pool is not active at this time.
    In the interim the table space will use buffer pool ID "4096". The
    inactive buffer pool should become available at next database startup
    provided that the required memory is available.
    and you may also find similar to this one

    MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
    "No Storage Available for allocation"
    DIA8305C Memory allocation failure occurred.
    DATA #1 : String, 287 bytes
    Failed to allocate the database shared memory set.
    The configured DATABASE_MEMORY plus smaller overflow may have
    exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
    Attempting to start up with only the system buffer pools.
    Database shared memory set size is (bytes):
    DATA #2 : unsigned integer, 8 bytes
    10718350540
    Its a memory issue

    DBFinder

  4. #4
    Join Date
    Mar 2009
    Posts
    16

    Bufferpool error

    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.

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by dr_te_z
    If problem persists you'll have to check&correct your memory settings.
    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
    Code:
    db2set DB2_OVERRIDE_BPF=256
    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 .

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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)

  7. #7
    Join Date
    Mar 2009
    Posts
    16

    Smile Got the solution

    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.

  8. #8
    Join Date
    Sep 2009
    Posts
    14
    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"

  9. #9
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    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.

  10. #10
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    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.
    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

  11. #11
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •