IC88927: SQLI_SMP_ERR ERROR DURING ROLLBACK OF FREE PAGE OPERATION ON AN INDEX

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During rollback of a free page operation DB2 may fail with error
    'SQLI_SMP_ERR' due to unexpectedly finding the page marked as
    used.
    
    The db2diag.log will show following severe error:
    
    2012-11-19-13.41.36.051203+060 I34708856A523      LEVEL: Severe
    PID     : 16515112             TID  : 21817       PROC : db2sysc
    0
    INSTANCE: TESTINST             NODE : 000         DB   : TESTDB
    APPHDL  : 0-38753              APPID:
    53.48.16.60.50795.121119123056
    AUTHID  : DB2ADMIN
    EDUID   : 21817                EDUNAME: db2agent (TESTDB) 0
    FUNCTION: DB2 UDB, index manager, sqliundo, probe:2310
    RETCODE : ZRC=0x87090052=-2029453230=SQLI_SMP_ERR "SMP problems"
              DIA8573C An invalid space map page was found.
    
    The transaction being rolled back must have performed the
    following in this order:
    - updates or deletes that triggered a page merge or page
    deletion in the index and that were performed with exclusive
    access to the table
    - runstats
    - rollback
    
    The table must have 1 or more indexes that were created when the
    table was empty (or that were rebuilt when the table was empty).
    At least one of the indexes must have had less than 25 distinct
    key values for the life of the index.
    

Local fix

  • Use db2dart /MI to mark affected indexes bad and have them
    rebuilt upon database restart or first access (based on INDEXREC
    configuration).
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 8.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88927

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-07

  • Closed date

    2013-04-08

  • Last modified date

    2013-04-08

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

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

    IC89032

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 #:

IC88927

Modified date:

2013-04-08

Translate my page

Machine Translation

Content navigation