If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > buffer_pool_services sqlbinit Probe:101 Database:DBTEST

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-01-06, 02:17
qxz qxz is offline
Registered User
 
Join Date: Apr 2002
Posts: 84
Question 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 ....
Reply With Quote
  #2 (permalink)  
Old 04-01-06, 05:17
przytula przytula is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On