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

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-14-09, 07:39
redwolf redwolf is offline
Registered User
 
Join Date: Apr 2004
Posts: 179
Table Corruption

Can someone tell what the error message below means? Its my understanding that db2 encounterred a checksum difference between what is in the buffer vs what is on disk for a table. We're trying to get to the root cause of an issue that caused us to restore from backup. Are these errors almost always related to a hardware issue?

We're running db2 V8 fixpack 15 on Solaris 10.

Thanks



2009-05-11-18.56.21.817090-240 I880A381 LEVEL: Error
PID : 12574 TID : 1 PROC : db2pfchr 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbReadAndReleaseBuffers, probe:17
RETCODE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page Header"
DIA8547C An error occurred in a database page header.

2009-05-11-18.56.21.857257-240 I1262A451 LEVEL: Error
PID : 12574 TID : 1 PROC : db2pfchr 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbReadAndReleaseBuffers, probe:17
DATA #1 : String, 172 bytes
Obj={pool:3;obj:2565;type:0} State=x27 Parent={3;2565}, EM=4552128, PP0=4552560 Page=4624000 Cont=19 Offset=220192 BlkSize=12
sqlbReadAndReleaseBuffers error: num-pages=16
Reply With Quote
  #2 (permalink)  
Old 05-14-09, 12:01
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
db2 is reading pages from disk and placing them into the bufferpool. Then, it checks the page it has just placed into the bufferpool for consistencies (ie. consistency bit, page header). It's during one of these checks that db2 gets this error. The error occurred when the page was referenced; however, the actual corruption could have occurred at an earlier time. Most corruptions are caused by some problem below db2 (ie. hardware failure). db2 defect is another possibility.
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