SAP Knowledge Base Article - Preview

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


  • Corruptions on indexes resulting in DIA8400C errors reported in the db2diag.log:
    2018-01-01- 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
    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




SAP Netweaver


SAP NetWeaver all versions


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.