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.
2009-05-11-220.127.116.117090-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.
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.