IBM Support

IT10760: INDEX/DATA MISMATCH MIGHT OCCUR IN AN MDC TABLE AFTER A DEFERRED ROLLOUT IS SUSPENDED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The error might occur when the following criteria are met:
    
    1) The table is an MDC table with at least two RID indexes.
    2) A deferred cleanup rollout delete is performed on that MDC
    table.
    3) Before the asynchronous index cleanup operation completes, it
    suspends due to lock timeout or deadlock, and another deferred
    cleanup rollout delete is performed on the table.
    4) As a result, it updates the block map incorrectly marking all
    rolled-out blocks as free even though the index cleanup is not
    complete. This might result in a variety of different index
    errors.  The problem can be detected by running the INSPECT
    command with the INDEXDATA option.
    
    You can see following output in db2diag.log when the async index
    cleanup suspends(3):
    
    2015-01-01-10.00.00.000000+540 E571009E589           LEVEL:
    Warning
    PID     : 123456               TID : 140179515893504 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-1234               APPID: *LOCAL.DB2.150101022705
    AUTHID  : DB2INST1             HOSTNAME: db2server
    EDUID   : 543210               EDUNAME: db2taskp (SAMPLE) 0
    FUNCTION: DB2 UDB, AIC, aicRolloutIndexCleanup, probe:2075
    MESSAGE : ADM9514I  BEGIN async index cleanup on table
    "DB2INST1.T1"
              (ID "123") and table space "TS1" (ID "5").
      ...
    
    2015-01-01-10.02.11.328114+540 I712797E573           LEVEL: Info
    PID     : 123456               TID : 140179515893504 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    SAMPLE
    APPHDL  : 3-14429              APPID: *N3.DB2.150701092140
    AUTHID  : DB2INST1             HOSTNAME: db2server
    EDUID   : 543210               EDUNAME: db2taskp (SAMPLE) 0
    FUNCTION: DB2 UDB, AIC, aicRolloutIndexCleanup, probe:4318
    MESSAGE : ZRC=0x82A90066=-2102853530=ABP_SUSPEND_TASK_PRO
              "Suspend the task processor"
    CALLED  : DB2 UDB, AIC, aicRolloutIndexCleanup
    

Local fix

  • If the problem occurs, rebuild the indexes.  To avoid the
    problem do not use deferred index cleanup.
    db2set DB2_MDC_ROLLOUT=IMMEDIATE
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 10.1 Fix Pack 6                               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 10.1 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT10760

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-08-18

  • Closed date

    2017-03-02

  • Last modified date

    2017-03-02

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

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

    IT10809 IT10810 IT10811 IT10812 IT10813

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN UP

       FIX

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 March 2017