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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content