IBM Support

IC69339: REPLAY OF CERTAIN INTERNAL INDEX OPERATIONS DURING ROLLFORWARD OR CRASH RECOVERY MAY FAIL WITH ERROR DIA8575C

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Replay of certain internal index operations when rolling
    forward, either as part of recovery or on an HADR standby, can
    lead to a miscalculation of the free space on an index page
    resulting in this error being reported:
    
    2010-05-14-21.58.21.582815+120 I18806675E585       LEVEL: Error
    PID     : 24382                TID  : 46912854026560PROC :
    db2sysc
    INSTANCE: INST1                  NODE : 000          DB   :
    SAMPLE
    APPHDL  : 0-17                 APPID: *LOCAL.DB2.100507185408
    EDUID   : 85                   EDUNAME: db2redow (SAMPLE)
    FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:155
    MESSAGE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
    error"
              DIA8575C An index manager programming error occurred.
    DATA #1 : <preformatted>
    REDO failed on LSO(LSN) 15666791888120 (00000E519B932CEF)
    
    This db2diag.log entry is preceded by a message of function
    sqliakn at probe 901:
    
    2010-05-14-21.58.21.465469+120 I18763255E646       LEVEL: Severe
    PID     : 24382                TID  : 46912854026560PROC :
    db2sysc
    INSTANCE: INST1                  NODE : 000          DB   :
    SAMPLE
    APPHDL  : 0-17                 APPID: *LOCAL.DB2.100507185408
    EDUID   : 85                   EDUNAME: db2redow (SAMPLE)
    FUNCTION: DB2 UDB, index manager, sqliakn, probe:901
    MESSAGE : slotinfo
    DATA #1 : Hexdump, 40 bytes
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Replay of certain internal index operations when             *
    * rollingforward, either as part of recovery or on an HADR     *
    * standby,canlead to a miscalculation of the free space on an  *
    * index pageresulting in this error being                      *
    * reported:2010-05-14-21.58.21.582815+120 I18806675E585        *
    * LEVEL:ErrorPID    : 24382                TID  :              *
    * 46912854026560PROC :db2syscINSTANCE: INST1                   *
    * NODE : 000          DB  :SAMPLEAPPHDL  : 0-17                *
    * APPID: *LOCAL.DB2.100507185408EDUID  : 85                    *
    * EDUNAME: db2redow (SAMPLE)FUNCTION: DB2 UDB, recovery        *
    * manager, sqlpRecDbRedo,probe:155MESSAGE :                    *
    * ZRC=0x87090054=-2029453228=SQLI_PRG_ERR                      *
    * "Programerror"DIA8575C An index manager programming          *
    * erroroccurred.DATA #1 : <preformatted>REDO failed on         *
    * LSO(LSN) 15666791888120 (00000E519B932CEF)This db2diag.log   *
    * entry is preceded by a message of functionsqliakn at probe   *
    * 901:2010-05-14-21.58.21.465469+120 I18763255E646             *
    * LEVEL:SeverePID    : 24382                TID  :             *
    * 46912854026560PROC :db2syscINSTANCE: INST1                   *
    * NODE : 000          DB  :SAMPLEAPPHDL  : 0-17                *
    * APPID: *LOCAL.DB2.100507185408EDUID  : 85                    *
    * EDUNAME: db2redow (SAMPLE)FUNCTION: DB2 UDB, index manager,  *
    * sqliakn, probe:901MESSAGE : slotinfoDATA #1 : Hexdump, 40    *
    * bytes                                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 FP3                                      *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 V9.7 FP3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC69339

  • 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

    2010-06-18

  • Closed date

    2010-09-27

  • Last modified date

    2010-09-27

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

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

    IC69801

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC69339

Modified date: 27 September 2010