SAP Knowledge Base Article - Preview

2099517 - How to mark an index as bad using DB2DART tool DIA8400C DIA8547C

Symptom

  • Corruptions on indexes resulting in DIA8400C errors reported in the db2diag.log:
    2018-01-01-00.00.00.000000-120 I6537A5463           LEVEL: Severe
    PID     : 0000000              TID : 11111          PROC : db2sysc 0
    INSTANCE: db2sid               NODE : 000           DB   : SID
    APPHDL  : 0-12345              APPID: *LOCAL.db2sid.180120120841
    AUTHID  : DB2SID               HOSTNAME: db2systemhost
    EDUID   : 70442                EDUNAME: db2agent (xxx) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:2
    MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
              DIA8400C A bad page was encountered.
    DATA #1 : String, 64 bytes
    Error encountered trying to read a page - information follows:
    DATA #2 : String, 23 bytes
    Page verification error
    DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
    53378940
    DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 104 bytes
        Obj: {pool:10;obj:1001;type:1} Parent={9;1000}
            Where obj: type:1 is an index
  • Corruptions on indexes resulting in DIA8547C errors reported in the db2diag.log:
    YYYY-MM-DD-24.MM.SS.msmsms+### I########A#### LEVEL: Severe
    PID : ####### TID : ##### PROC : db2sysc 0
    INSTANCE: db2<sid> NODE : 000 DB : <SID>
    APPHDL : 0-#### APPID: *LOCAL.db2<sid>.############
    AUTHID : DB2<SID> HOSTNAME: <db2srvhostnm>
    EDUID : ##### EDUNAME: db2agent (<SID>) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:19
    MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page Header"
    DIA8547C An error occurred in a database page header.
    DATA #1 : String, 64 bytes
    Error encountered trying to read a page - information follows :
    DATA #2 : String, 23 bytes
    Page verification error
    DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
    4996
    DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 104 bytes
       Obj: {pool:7;obj:461;type:65} Parent={6;472}
          where obj: type:65 is EMP of an index object

 


Read more...

Environment

Db2 LUW
SAP Netweaver

Product

SAP NetWeaver all versions

Keywords

bad page header DIA8400C DIA8547C , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.