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

SAP Knowledge Base Articles - preview

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


Corruptions on indexes resulting in DIA8400C errors like below:

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 (QBB) 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}



DB2 on LUW


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.