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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
