IBM Support

IC87345: ROWS MIGHT BE INSERTED INTO WRONG MDC TABLE CELL AFTER PREVIOUS INSERTS IN SAME TRANSACTION ENCOUNTER TABLESPACE FULL

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If inserts into the MDC table encounter tablespace full, the
    subsequent inserts within the same transaction, with same block
    index values, might place rows into the wrong MDC table extent.
    The problem only occurs if after encountering the error during
    insert, the transaction is not committed nor rolled back and
    subsequent inserts continue to be attempted from the same
    transaction.
    
    The problem might occur without the tablespace error if an
    interrupt is received or an out of memory error occurs in a very
    small window.
    
    The INSPECT command with the BLOCKDATA option (similar to
    INDEXDATA) performs block index to data consistency check and
    detects if any rows are misplaced.
    

Local fix

  • Run INSPECT with the BLOCKDATA option to perform block index to
    data consistency check. If a problem is detected, use LOAD from
    cursor to insert into a copy of the MDC table to correct the
    problem.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * 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

    IC87345

  • 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-10-18

  • Closed date

    2013-03-25

  • Last modified date

    2013-03-26

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

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

    IC87497 IC87498 IC87500

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

Modified date: 26 March 2013