|
Problem IT35548
|
Status: Closed |
Possible HADR standby shutdown when replay only window avoidanceis active
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
Error Description: Replay of log records on a HADR standby with
replay only window avoidance active could result
in the standby being shut down. Following are examples of errors
that will be reported in the db2diag.log
2020-12-15-08.15.51.793009+060 I57113121E1037 LEVEL: Severe
PID : 56510 TID : 138181462714112 PROC : db2sysc 0
INSTANCE: XXXXXX NODE : 000 DB : XXXXXX
APPHDL : 0-16 APPID: XXXXXXXXXX
HOSTNAME: XXXXXXXXXXx
EDUID : 413 EDUNAME: db2redom (XXX) 0
FUNCTION: DB2 UDB, data management, pend_DropTable, probe:1756
MESSAGE : Object is not marked PENDDEL!!
and
2021-05-15-11.39.58.095927-240 I3238141E193 LEVEL: Severe
PID:16246 TID:139286930253568 NODE:000 Title: SQLD_REORG_CB
Dump File:XXXXX
2021-05-15-11.39.58.237873-240 I3238335E566 LEVEL:
Severe
PID : 16246 TID : 139286930253568 PROC :
db2sysc 0
INSTANCE: XXXXX NODE : 000 DB :
XXXXX
APPHDL : 0-77 APPID: *LOCAL.DB2.210508114314
HOSTNAME: XXXXX
EDUID : 298 EDUNAME: db2redom (XXXXX) 0
FUNCTION: DB2 UDB, data management, sqldomRedo, probe:1795
RETCODE : ZRC=0x87040055=-2029780907=SQLD_PRGERR "Unknown
PROGRAM ERROR"
DIA8576C A data management services programming error
occurred. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.1 or higher *
**************************************************************** |
| Local Fix: |
Issue can be avoided by using db2set
DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW=OFF |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.1 or higher *
**************************************************************** |
| Comment |
Upgrade to Db2 11.5.5.1 or higher |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.01.2021
31.03.2021
10.08.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
