2099517 - How to mark an index as bad using DB2DART tool | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

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

 


Read more...

Environment

Db2 LUW
SAP Netweaver

Product

SAP NetWeaver all versions

Keywords

bad page header DIA8400C , 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 ONE Support launchpad (Login required).

Search for additional results

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