Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    1

    Unanswered: DIA8426C A invalid page checksum was found for page

    Hi,

    Is there any quick way (withjoiut restoring) to recover from this error? It's on a VMware system that I can roll-back but it has happened twice now and would like to know how to fix it?

    Simon

    2008-03-05-23.20.09.442000+000 I10768117H640 LEVEL: Severe
    PID : 2216 TID : 2948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : WAREHOUS
    APPHDL : 0-14 APPID: *LOCAL.DB2.080305232000
    AUTHID : ADMINISTRATOR
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1150
    MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
    DIA8426C A invalid page checksum was found for page "".
    DATA #1 : <preformatted>
    Failed to read page from disk on attempt number 1.
    Retrying operation. Only subsequent failures will be logged.

    2008-03-05-23.20.09.442000+000 I10768759H1666 LEVEL: Severe
    PID : 2216 TID : 2948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : WAREHOUS
    APPHDL : 0-14 APPID: *LOCAL.DB2.080305232000
    AUTHID : ADMINISTRATOR
    FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
    MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
    DIA8426C A invalid page checksum was found for page "".
    DATA #1 : String, 64 bytes
    Error encountered trying to read a page - information follows :
    DATA #2 : String, 95 bytes
    CBIT verification error
    bitExpected is 0, userByte is 1, sector 7 (from head of page, 0 based)
    DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
    64995
    DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 68 bytes
    Obj: {pool:2;obj:2832;type:1} Parent={2;2832}
    lifeLSN: 00008984C3BF
    tid: 0 0 0
    extentAnchor: 64960
    initEmpPages: 0
    poolPage0: 64992
    poolflags: 3122
    objectState: 27
    lastSMP: 0
    pageSize: 4096
    extentSize: 32
    bufferPoolID: 1
    partialHash: 168820738
    bufferPool: 0x06fdd290
    DATA #5 : Bitmask, 4 bytes
    0x00000002
    DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
    pageHead: {pool:2;obj:2832;type:1} PPNum:64995 OPNum:3
    begoff: 48
    datlen: 4048
    pagebinx: 274
    revnum: 1024
    pagelsn: 000155EA6420 flag: 6
    signature: 1206056196
    cbits1to31: 0
    cbits32to63: 0

  2. #2
    Join Date
    Jan 2008
    Posts
    88
    try to use dbdart and it will which page is corrupted..drop the object and recreate it

Posting Permissions

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