IC89290: INDEX CORRUPTION MIGHT BE INTRODUCED DURING A DATABASE UPGRADE TO DB2 VERSION 9.7

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During a database upgrade to DB2 Version 9.7, index corruption
    might be introduced.  This is caused by the DB2 code that
    upgrades the index root page to Version 9.7 if the following
    conditions are true:
    - the index was created with both the UNIQUE and INCLUDE
    keywords
    - at least one of the columns specified in the INCLUDE clause of
    the CREATE INDEX statement is a variable length column
    - the only variable length columns in the index are specified in
    the INCLUDE clause of the CREATE INDEX statement
    - the index contains more than one level
    
    If db2dart is run with the /DB option immediately after the
    upgrade, the following error message might appear in the report:
    
     Error: BPS check read error for pool page <PageNumber>, from
    object ID <ObjectID>, pool <PoolID>,
    
    If db2dart is not run immediately after the upgrade, a number of
    different symptoms might occur, such as the following message in
    the db2diag.log:
    
    2013-01-11-14.01.52.435086-300 I1705E3859          LEVEL: Severe
    PID     : 763                  TID  : 46912946301248PROC:
    db2sysc
    INSTANCE: dbuser               NODE : 000          DB   : SAMPLE
    APPHDL  : 0-7                  APPID: *LOCAL.dbuser.130111190139
    AUTHID  : DBUSER
    EDUID   : 16                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page,
    probe:12
    MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
    Header"
              DIA8547C An error occurred in a database page header.
    
    The following query can be used to identify indexes that might
    be affected:
    
    select distinct t2.TBSPACEID, t2.TABLEID, t1.IID,
           t1.TABSCHEMA, t1.TABNAME, t1.INDSCHEMA, t1.INDNAME
       from syscat.indexes as t1,
            syscat.tables as t2
       where t1.UNIQUE_COLCOUNT >= 1
       and t1.UNIQUE_COLCOUNT < t1.COLCOUNT
       and t1.TABSCHEMA = t2.TABSCHEMA
       and t1.TABNAME = t2.TABNAME
       and t1.UNIQUE_COLCOUNT <
           (select min(t3.COLSEQ)
               from syscat.indexColUse as t3,
                    syscat.columns as t4
               where t1.INDSCHEMA = t3.INDSCHEMA
               and t1.INDNAME = t3.INDNAME
               and t1.TABSCHEMA = t4.TABSCHEMA
               and t1.TABNAME = t4.TABNAME
               and t3.COLNAME = t4.COLNAME
               and t4.TYPENAME = 'VARCHAR'
               and t4.TYPESCHEMA = 'SYSIBM'
               with ur)
       with ur;
    

Local fix

  • REORG the corrupted indexes or mark the index as bad by using
    the db2dart option /MI.  When completed, rebuild it by accessing
    the table.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users upgrade to DB2 version 9.7                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7.0.8.                              *
    ****************************************************************
    

Problem conclusion

  • The problem is first fixed in DB2 version 9.7.0.8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89290

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-27

  • Closed date

    2013-03-25

  • Last modified date

    2013-03-26

  • APAR is sysrouted FROM one or more of the following:

    IC89288

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC89290

Modified date:

2013-03-26

Translate my page

Machine Translation

Content navigation