DB2 databse got corrupt with 'Bad Page' error message
Issue
- DB2 databse got crashed with page corruption issue.
-
At the time of database corruption, following 'Bad Page' error message were logged:
Feb 11 03:15:58 DBHOST1 DB2[24626]: 2015-02-11-03.15.58.659657+480 I1138689E3704 LEVEL: Severe PID : 24626 TID : 11111844079424PROC : db2sysc 0 INSTANCE: inst1 NODE : 000 EDUID : 96 EDUNAME: db2pfchr (IDEBBS) 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 7966407 DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes Obj: {pool:4;obj:29699;type:0} Parent={4;29699} lifeLSN: 000003BB8F760B0A tid: 0 0 0 extentAnchor: 5464512 initEmpPages: 0 poolPage0: 0 poolflags: 2122 objectState: 27
Environment
- Red Hat Enterprise Linux 5.6
- IBM DB2 databse
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.