invispix 10x10
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT41276 Status: Closed

SUSTAINED TRAP ON HADR STANDBY BLOCKS REPLAY-ONLY WINDOW

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
This problem only occurs on HADR standby database with the
Reads On Standby (ROS) feature enabled.

When the standby database replays a DDL or maintenance
operation that requires a replay-only window, it needs to force
off all ROS connections.  This step can be blocked when there
is suspended EDU due to a previous trap that can be sustained.
The log replay on the standby will be blocked.

Below is an example of the stack dump of the db2redom EDU
that encounters this problem:

      0x0900000000113994 thread_wait + 0x94
      0x09000000141F26F4 sqloWaitEDUWaitPost + 0x1D4
      0x090000001367E540
HdrForceAppsInReplayOnlyWindow__16sqeLocalDatabaseFP8sqeAgent +
0xAFC
      0x0900000013677D84
sqlpPRecReadLog__FP8sqeAgentP8SQLP_ACBP9SQLP_DBCB + 0x12A8
      0x0900000016296EB8
sqlpParallelRecovery__FP8sqeAgentP5sqlca + 0x14
      0x090000001347C500 sqleSubCoordProcessRequest__FP8sqeAgent
+ 0x1F8
      0x090000001457A3D4 RunEDU__8sqeAgentFv + 0x3AC
      0x09000000140BDE3C EDUDriver__9sqzEDUObjFv + 0xF8
      0x09000000140C3580 sqloEDUEntry + 0x264


After encountering this problem, the only way to resolve is to
recycle the standby instance.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 V12.1                                         *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 V12.1                                         *
****************************************************************
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.06.2022
04.07.2022
04.07.2022
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

invispix 10x10