DB2 - Problem description
Problem IT33122 | Status: Closed |
STANDBY HOST FOR PARTITIONS IS NOT UPDATED IN A DPF ENVIRONMENT WITH THE ROVING HA FEATURE ENABLED | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
In a HA DPF environment with the roving HA feature enabled, it is possible that the roving HA feature does not function as expected. Take for example, a three host environment with two Db2 partitions, where partition 0 is active on hostA and partition 1 is active on hostB and where hostC is the standby location for both partitions. In this case, the resource model for partitions 0 and 1 would looks as follows in the lssam output: Online IBM.ResourceGroup:db2_db2inst1_0-rg Nominal=Online |- Online IBM.Application:db2_db2inst1_0-rs |- Online IBM.Application:db2_db2inst1_0-rs:hostA '- Offline IBM.Application:db2_db2inst1_0-rs:hostC Online IBM.ResourceGroup:db2_db2inst1_1-rg Nominal=Online |- Online IBM.Application:db2_db2inst1_1-rs |- Online IBM.Application:db2_db2inst1_1-rs:hostB '- Offline IBM.Application:db2_db2inst1_1-rs:hostC If the roving HA feature is enabled in this environment, then it is expected that the resource model is dynamically updated to look as follows after hostB encounters a failure causing partition 1 to failover to hostC: Online IBM.ResourceGroup:db2_db2inst1_0-rg Nominal=Online |- Online IBM.Application:db2_db2inst1_0-rs |- Online IBM.Application:db2_db2inst1_0-rs:hostA '- Offline IBM.Application:db2_db2inst1_0-rs:hostB Online IBM.ResourceGroup:db2_db2inst1_1-rg Nominal=Online |- Online IBM.Application:db2_db2inst1_1-rs |- Offline IBM.Application:db2_db2inst1_1-rs:hostB '- Online IBM.Application:db2_db2inst1_1-rs:hostC As you can see in the above lssam output, partition 0 is still running on hostA, but hostB is now its designated standby, whereas partition 1 is now running on hostC (its new active node) and hostB is now its standby location. The roving HA feature makes it so that there is always a single standby location for all active partitions in the cluster. If the roving HA feature enabled, and this dynamic updating of the resource model is not occurring, it may be due to this APAR. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DPF ROVING HA FEATURE users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 V11.1.4.6 * **************************************************************** | |
Local Fix: | |
Contact IBM support for a fix. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.06.2020 31.03.2021 31.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |