|
Problem IC77899
|
Status: Closed |
ASYNCHRONOUS INDEX CLEANUP FAILS ON THE STAND-BY MACHINE IN AN HADR-PAIR |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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 task
processor
context is "0x070000012CE511A0". The task processor
description is
"MDC Rollout Index Cleaner". |
| 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. *
**************************************************************** |
| Local Fix: |
Contact DB2 support for assistance in removing the MDC Rollout
Index Cleaner task processor that is in error state. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The problem is first fixed in DB2 9.7.0.5. |
| Workaround |
Contact DB2 support for assistance in removing the MDC Rollout
Index Cleaner task processor that is in error state. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.08.2011
08.12.2011
08.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0.5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
