suche 36x36
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 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)