DB2 - Problem description
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) |