Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    84

    Question Unanswered: buffer_pool_services sqlbinit Probe:101 Database:DBTEST

    Dear All,

    I have the following errors in db2diag.log, and similar error in
    event view. Any hint what could go wrong? URGENT! Thanks
    for your help.

    --------------------------------------------------------------
    2006-04-01-15.00.39.343000 InstanceB2 Node:000
    PID:216(db2syscs.exe) TID:2452 Appid:*LOCAL.DB2.0612338
    buffer_pool_services sqlbinit Probe:103 DatabaseBTEST

    The memory for bufferpool and estore cannot be allocated: 0000 0800 ....


    2006-04-01-15.00.39.375000 InstanceB2 Node:000
    PID:216(db2syscs.exe) TID:2452 Appid:*LOCAL.DB2.0612338
    buffer_pool_services sqlbinit Probe:101 DatabaseBTEST

    Database is starting up with only one buffer pool of size: 1000 0000 ....

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    buffer

    when starting the instance, the bufferpool is trying to be allocated
    not enough memory is available, so minimal bufferpool is allocated
    - try to stop processes that use much memory
    - allocate smaller bufferpool
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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