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.
SAP Knowledge Base Article - Preview