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 > A buffer pool logic error has occurred. (DIA3801C)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-06-04, 18:45
dcazares dcazares is offline
Registered User
 
Join Date: Jun 2004
Posts: 10
A buffer pool logic error has occurred. (DIA3801C)

Hello,

I am using DB2 7.2.0 on windows 2000 server,

I have 5 tablespaces each one is with your buffer pool (now)
originally was created with ibmdefaultbp, but I create a buffer pool foreach table space.

the last tablespace had a own buffer pool, but it was droped an assigned a new buffer pool o the same page size.

when execute db2start I have the following messages in the db2diag.log

Please help me!!

Regards,

Diego Cazares

------------------------

2004-07-06-17.10.27.000001 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbinit Probe:256 Database: DAC_DB

WARNING: estore is being used for multiple page sizes performance may not be optimal0080 0000 .€..


2004-07-06-17.10.27.031000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbinit Probe:245 Database: DAC_DB

WARNING: estore is OFF but bufferpools are configured to use it 0000 0000 ....


2004-07-06-17.10.27.359000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbinit Probe:103 Database: DAC_DB

The memory for bufferpool and estore cannot be allocated: 18b6 0900 .¶ .


2004-07-06-17.10.27.375000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbinit Probe:105 Database: DAC_DB

Database is starting up with tiny bufferpools.
Number of bufferpools coming up: 0600 0000 ....


String Title:sqlbinit PID:1824 Node:000
Probe 106. Database is starting up with 2 small buffer pools
each of size 16 pages

2004-07-06-17.10.27.453000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbStartPools Probe:2 Database: DAC_DB

Tablespace 0 was mapped to BufferPool 3 which does not exist or currently is the wrong pagesize.
It will be mapped to BufferPool 1.


2004-07-06-17.10.27.500000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbStartPools Probe:2 Database: DAC_DB

Tablespace 1 was mapped to BufferPool 4 which does not exist or currently is the wrong pagesize.
It will be mapped to BufferPool 1.


2004-07-06-17.10.27.515000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbStartPools Probe:2 Database: DAC_DB

Tablespace 2 was mapped to BufferPool 5 which does not exist or currently is the wrong pagesize.
It will be mapped to BufferPool 1.


2004-07-06-17.10.27.718000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbStartPools Probe:22 Database: DAC_DB

Tablespace 3 was mapped to BufferPool 6 which doesnot exist or currently is the wrong pagesize.
No bufferpool with pagesize 32768 exists.


2004-07-06-17.10.27.718001 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbStartPools Probe:0 Database: DAC_DB
DIA3801C A buffer pool logic error has occurred.

ZRC=FFFFF102

2004-07-06-17.10.27.750000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
buffer_pool_services sqlbinit Probe:125 Database: DAC_DB
DIA3801C A buffer pool logic error has occurred.

ZRC=FFFFF102

2004-07-06-17.10.27.765000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
base_sys_utilities sqledint Probe:12 Database: DAC_DB

DiagData
02f1 ffff .ñÿÿ


2004-07-06-17.10.27.781000 Instance: DB2 Node:000
PID:1824(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.040706221026
base_sys_utilities sqledint Probe:12 Database: DAC_DB

RIDS/sqledint MS/INS_SYS_RES PRCS/1202f1 ffff .ñÿÿ


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