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
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.