IBM Support

IC77899: ASYNCHRONOUS INDEX CLEANUP FAILS ON THE STAND-BY MACHINE IN AN HADR-PAIR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When using the deferred type of rollout cleanup on DELETE
    statements for multidimensional clustering (MDC) tables in an
    HADR-pair, the stand-by machine may encounter an error during
    asynchronous index cleanup.  The index cleanup on the standby
    machine will occur by replaying the index cleanup log records
    from the primary machine.  DB2 should not be starting an
    asynchronous index cleanup job on the standby machine and
    this job will be placed into error state when it is started.
    
    Deferred rollout cleanup can be specified by one of the
    following:
    - the CURRENT MDC ROLLOUT MODE special register
    - setting the registry variable DB2_MDC_ROLLOUT to DEFER
    
    The following errors will be seen in the db2diag.log on the
    stand-by machine:
    
    2011-07-29-21.21.42.130032-240 I89255A537         LEVEL: Warning
    PID     : 1060916              TID  : 17309       PROC : db2sysc
    INSTANCE: ztoth                NODE : 000         DB   : HADRDB
    APPHDL  : 0-27                 APPID: *LOCAL.DB2.110730012143
    AUTHID  : ZTOTH
    EDUID   : 17309                EDUNAME: db2taskp (HADRDB)
    FUNCTION: DB2 UDB, AIC, aicRolloutUpdateBlockMap, probe:590
    MESSAGE : ZRC=0x80100469=-2146433943=SQLP_HDRS_READ_ONLY
              "The operation that attempted to modify the contents
    of the database failed"
    
    2011-07-29-21.21.42.130357-240 I89793A6811        LEVEL: Error
    PID     : 1060916              TID  : 17309       PROC : db2sysc
    INSTANCE: ztoth                NODE : 000         DB   : HADRDB
    APPHDL  : 0-27                 APPID: *LOCAL.DB2.110730012143
    AUTHID  : ZTOTH
    EDUID   : 17309                EDUNAME: db2taskp (HADRDB)
    FUNCTION: DB2 UDB, AIC, aicRolloutIndexCleanup, probe:2060
    MESSAGE : ZRC=0x80100469=-2146433943=SQLP_HDRS_READ_ONLY
              "The operation that attempted to modify the contents
    of the database failed"
    
    ...
    
    2011-07-29-21.21.42.130965-240 I96605A638         LEVEL: Error
    PID     : 1060916              TID  : 17309       PROC : db2sysc
    INSTANCE: ztoth                NODE : 000         DB   : HADRDB
    APPHDL  : 0-27                 APPID: *LOCAL.DB2.110730012143
    AUTHID  : ZTOTH
    EDUID   : 17309                EDUNAME: db2taskp (HADRDB)
    FUNCTION: DB2 UDB, AIC, aicTaskProcessorCleanup, probe:846
    MESSAGE : ZRC=0x80100469=-2146433943=SQLP_HDRS_READ_ONLY
              "The operation that attempted to modify the contents
    of the database failed"
    RETCODE : ZRC=0x82A90067=-2102853529=ABP_TASK_PRO_ERROR
              "Task processor encountered an error"
    
    ...
    
    2011-07-29-21.21.42.145343-240 I104374A1400       LEVEL: Error
    PID     : 1060916              TID  : 17309       PROC : db2sysc
    INSTANCE: ztoth                NODE : 000         DB   : HADRDB
    APPHDL  : 0-27                 APPID: *LOCAL.DB2.110730012143
    AUTHID  : ZTOTH
    EDUID   : 17309                EDUNAME: db2taskp (HADRDB)
    FUNCTION: DB2 UDB, AIC, aicRolloutTaskProcessor, probe:2050
    MESSAGE : ZRC=0x82A90067=-2102853529=ABP_TASK_PRO_ERROR
              "Task processor encountered an error"
    DATA #1 : String, 18 bytes
    pAicTaskProHandle:
    DATA #2 : Hexdump, 40 bytes
    0x07000000AF3FE258 : 0700 0001 2CE5 11A0 0700 0001 2CE5 1208
    ....,.......,...
    0x07000000AF3FE268 : 0000 0000 0000 0000 0700 0001 2CE5 1298
    ............,...
    0x07000000AF3FE278 : 0000 0000 0000 0000
    ........
    DATA #3 : AIC_RO_TASK_PRO_INFO, PD_AIC_TYPE_RO_TASK_PRO_INFO, 72
    bytes
    
    ...
    
    2011-07-29-21.21.42.145779-240 E105775A833        LEVEL: Error
    PID     : 1060916              TID  : 17309       PROC : db2sysc
    INSTANCE: ztoth                NODE : 000         DB   : HADRDB
    APPHDL  : 0-27                 APPID: *LOCAL.DB2.110730012143
    AUTHID  : ZTOTH
    EDUID   : 17309                EDUNAME: db2taskp (HADRDB)
    FUNCTION: DB2 UDB, ABP,
    ABPDispatcher::updateAssignedTaskProCont, probe:100
    MESSAGE : ADM13500E  An agent executing an asynchronous
    background task
              processor encountered an unrecoverable error. The task
    processor has
              been suspended and diagnostic information was written
    to the db2diag
              log file. Contact IBM Support for assistance. The task
    processor
              context is "0x070000012CE511A0". The task processor
    description is
              "MDC Rollout Index Cleaner".
    

Local fix

  • Contact DB2 support for assistance in removing the MDC Rollout
    Index Cleaner task processor that is in error state.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users using an HADR configuration                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When using the deferred type of rollout cleanup on DELETE    *
    * statements for multidimensional clustering (MDC) tables in   *
    * an                                                           *
    * HADR-pair, the stand-by machine may encounter an error       *
    * during                                                       *
    * asynchronous index cleanup.  The index cleanup on the        *
    * standby                                                      *
    * machine will occur by replaying the index cleanup log        *
    * records                                                      *
    * from the primary machine.  DB2 should not be starting an     *
    * asynchronous index cleanup job on the standby machine and    *
    * this job will be placed into error state when it is started. *
    *                                                              *
    * Deferred rollout cleanup can be specified by one of the      *
    * following:                                                   *
    * - the CURRENT MDC ROLLOUT MODE special register              *
    * - setting the registry variable DB2_MDC_ROLLOUT to DEFER     *
    *                                                              *
    * The following errors will be seen in the db2diag.log on the  *
    * stand-by machine:                                            *
    *                                                              *
    * 2011-07-29-21.21.42.130032-240 I89255A537        LEVEL:      *
    * Warning                                                      *
    * PID    : 1060916              TID  : 17309      PROC :       *
    * db2sysc                                                      *
    * INSTANCE: ztoth                NODE : 000        DB  :       *
    * HADRDB                                                       *
    * APPHDL  : 0-27                APPID: *LOCAL.DB2.110730012143 *
    * AUTHID  : ZTOTH                                              *
    * EDUID  : 17309                EDUNAME: db2taskp (HADRDB)     *
    * FUNCTION: DB2 UDB, AIC, aicRolloutUpdateBlockMap, probe:590  *
    * MESSAGE : ZRC=0x80100469=-2146433943=SQLP_HDRS_READ_ONLY     *
    *           "The operation that attempted to modify the        *
    * contents                                                     *
    * of the database failed"                                      *
    *                                                              *
    *                                                              *
    * 2011-07-29-21.21.42.130357-240 I89793A6811        LEVEL:     *
    * Error                                                        *
    * PID    : 1060916              TID  : 17309      PROC :       *
    * db2sysc                                                      *
    * INSTANCE: ztoth                NODE : 000        DB  :       *
    * HADRDB                                                       *
    * APPHDL  : 0-27                APPID: *LOCAL.DB2.110730012143 *
    *                                                              *
    * AUTHID  : ZTOTH                                              *
    *                                                              *
    * EDUID  : 17309                EDUNAME: db2taskp (HADRDB)     *
    *                                                              *
    * FUNCTION: DB2 UDB, AIC, aicRolloutIndexCleanup, probe:2060   *
    *                                                              *
    * MESSAGE : ZRC=0x80100469=-2146433943=SQLP_HDRS_READ_ONLY     *
    *                                                              *
    *           "The operation that attempted to modify the        *
    * contents                                                     *
    * of the database failed"                                      *
    *                                                              *
    * ...                                                          *
    *                                                              *
    * 2011-07-29-21.21.42.130965-240 I96605A638        LEVEL:      *
    * Error                                                        *
    * PID    : 1060916              TID  : 17309      PROC :       *
    * db2sysc                                                      *
    * INSTANCE: ztoth                NODE : 000        DB  :       *
    * HADRDB                                                       *
    * APPHDL  : 0-27                APPID: *LOCAL.DB2.110730012143 *
    *                                                              *
    * AUTHID  : ZTOTH                                              *
    *                                                              *
    * EDUID  : 17309                EDUNAME: db2taskp (HADRDB)     *
    *                                                              *
    * FUNCTION: DB2 UDB, AIC, aicTaskProcessorCleanup, probe:846   *
    *                                                              *
    * MESSAGE : ZRC=0x80100469=-2146433943=SQLP_HDRS_READ_ONLY     *
    *                                                              *
    *           "The operation that attempted to modify the        *
    * contents                                                     *
    * of the database failed"                                      *
    * RETCODE : ZRC=0x82A90067=-2102853529=ABP_TASK_PRO_ERROR      *
    *                                                              *
    *           "Task processor encountered an error"              *
    *                                                              *
    * ...                                                          *
    *                                                              *
    * 2011-07-29-21.21.42.145343-240 I104374A1400      LEVEL:      *
    * Error                                                        *
    * PID    : 1060916              TID  : 17309      PROC :       *
    * db2sysc                                                      *
    * INSTANCE: ztoth                NODE : 000        DB  :       *
    * HADRDB                                                       *
    * APPHDL  : 0-27                APPID: *LOCAL.DB2.110730012143 *
    *                                                              *
    * AUTHID  : ZTOTH                                              *
    * EDUID  : 17309                EDUNAME: db2taskp (HADRDB)     *
    * FUNCTION: DB2 UDB, AIC, aicRolloutTaskProcessor, probe:2050  *
    * MESSAGE : ZRC=0x82A90067=-2102853529=ABP_TASK_PRO_ERROR      *
    *           "Task processor encountered an error"              *
    * DATA #1 : String, 18 bytes                                   *
    * pAicTaskProHandle:                                           *
    * DATA #2 : Hexdump, 40 bytes                                  *
    * 0x07000000AF3FE258 : 0700 0001 2CE5 11A0 0700 0001 2CE5 1208 *
    * ....,.......,...                                             *
    * 0x07000000AF3FE268 : 0000 0000 0000 0000 0700 0001 2CE5 1298 *
    * ............,...                                             *
    *                                                              *
    * 0x07000000AF3FE278 : 0000 0000 0000 0000                     *
    * ........                                                     *
    *                                                              *
    * DATA #3 : AIC_RO_TASK_PRO_INFO,                              *
    * PD_AIC_TYPE_RO_TASK_PRO_INFO, 72 bytes                       *
    *                                                              *
    * ...                                                          *
    *                                                              *
    * 2011-07-29-21.21.42.145779-240 E105775A833        LEVEL:     *
    * Error                                                        *
    * PID    : 1060916              TID  : 17309      PROC :       *
    * db2sysc                                                      *
    * INSTANCE: ztoth                NODE : 000        DB  :       *
    * HADRDB                                                       *
    * APPHDL  : 0-27                APPID: *LOCAL.DB2.110730012143 *
    * AUTHID  : ZTOTH                                              *
    * EDUID  : 17309                EDUNAME: db2taskp (HADRDB)     *
    * FUNCTION: DB2 UDB, ABP,                                      *
    * ABPDispatcher::updateAssignedTaskProCont, probe:100          *
    * MESSAGE : ADM13500E  An agent executing an asynchronous      *
    * background task                                              *
    *           processor encountered an unrecoverable error. The  *
    * task processor has                                           *
    *           been suspended and diagnostic information was      *
    * written to the db2diag                                       *
    *           log file. Contact IBM Support for assistance. The  *
    * taskprocessor                                                *
    *           context is "0x070000012CE511A0". The task          *
    * processor description is                                     *
    *           "MDC Rollout Index Cleaner".                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7.0.5.                                      *
    ****************************************************************
    

Problem conclusion

  • The problem is first fixed in DB2 9.7.0.5.
    

Temporary fix

  • Contact DB2 support for assistance in removing the MDC Rollout
    Index Cleaner task processor that is in error state.
    

Comments

APAR Information

  • APAR number

    IC77899

  • 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

    2011-08-03

  • Closed date

    2011-12-08

  • Last modified date

    2011-12-08

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

  • 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



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77899

Modified date: 08 December 2011