DB2 databse got corrupt with 'Bad Page' error message

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.