Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    190

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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    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.

Posting Permissions

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