home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT03051 Status: Geschlossen

TAKEOVER HADR COMMAND SUCCEEDS BUT RESOURCE GROUP REPORTS FAILED OFFLINE IN
LSSAM OUTPUT

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
In a TSA/HADR high availability environment configured using 
db2haicu, if the public network adapters of the standby and 
primary nodes are defined within two separate network 
equivalency groupings, i.e. as seen in this "lssam -V" output: 
 
Online IBM.ResourceGroup:db2_db2inst1_host03_0-rg Nominal=Online 
 
        '- Online IBM.Application:db2_db2inst1_host03_0-rs 
-. 
                '- Online 
IBM.Application:db2_db2inst1_host03_0-rs:host03          | 
 
Online IBM.ResourceGroup:db2_db2inst1_host04_0-rg Nominal=Online 
| 
        '- Online IBM.Application:db2_db2inst1_host04_0-rs 
| -. 
                '- Online 
IBM.Application:db2_db2inst1_host04_0-rs:host04          |  | 
 
Online IBM.ResourceGroup:db2_db2inst1_db2inst1_HADRDB-rg 
Nominal=Online            |  | 
        '- Online 
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs 
|  | -. -. 
                |- Online 
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:host03   |  |  | 
| 
                '- Offline 
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:host04  |  |  | 
| 
Online IBM.Equivalency:db2_db2inst1_host03_0-rg_group-equ 
|  |  |  | 
        '- Online IBM.PeerNode:host03:host03 
|  |  |  | 
Online IBM.Equivalency:db2_db2inst1_host04_0-rg_group-equ 
|  |  |  | 
        '- Online IBM.PeerNode:host04:host04 
|  |  |  | 
Online IBM.Equivalency:db2_db2inst1_db2inst1_HADRDB-rg_group-equ 
|  |  |  | 
        |- Online IBM.PeerNode:host03:host03 
|  |  |  | 
        '- Online IBM.PeerNode:host04:host04 
DO  |  | DO 
Online IBM.Equivalency:db2_public_network_0 
<'  |  | <' 
        '- Online IBM.NetworkInterface:eth0:host03 
DO DO 
Online IBM.Equivalency:db2_public_network_1 
<' <' 
        '- Online IBM.NetworkInterface:eth1:host04 
 
 
then issuing a takeover HADR command on the database will 
succeed, but it will leave the resource model in the following 
state, as seen by "lssam": 
 
Online IBM.ResourceGroup:db2_db2inst1_host03_0-rg Nominal=Online 
        '- Online IBM.Application:db2_db2inst1_host03_0-rs 
                '- Online 
IBM.Application:db2_db2inst1_host03_0-rs:host03 
Online IBM.ResourceGroup:db2_db2inst1_host04_0-rg Nominal=Online 
        '- Online IBM.Application:db2_db2inst1_host04_0-rs 
                '- Online 
IBM.Application:db2_db2inst1_host04_0-rs:host04 
Failed offline IBM.ResourceGroup:db2_db2inst1_db2inst1_HADRDB-rg 
Binding=Sacrificed Nominal=Online 
        '- Offline 
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs 
                |- Offline 
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:host03 
                '- Offline 
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:host04 
Online IBM.Equivalency:db2_db2inst1_host03_0-rg_group-equ 
        '- Online IBM.PeerNode:host03:host03 
Online IBM.Equivalency:db2_db2inst1_host04_0-rg_group-equ 
        '- Online IBM.PeerNode:host04:host04 
Online IBM.Equivalency:db2_db2inst1_db2inst1_HADRDB-rg_group-equ 
        |- Online IBM.PeerNode:host03:host03 
        '- Online IBM.PeerNode:host04:host04 
Online IBM.Equivalency:db2_public_network_0 
        '- Online IBM.NetworkInterface:eth0:host03 
Online IBM.Equivalency:db2_public_network_1 
        '- Online IBM.NetworkInterface:eth1:host04 
 
As seen above, the HADR resource group is left in a "Failed 
Offline" state. In order to recover from this state, log in as 
root from either node and issue the following sequence of 
commands: 
 
1) export CT_MANAGEMENT_SCOPE=2 
2) rgreq -o lock db2_db2inst1_db2inst1_HADRDB-rg 
3) rmrel -s "Name like 'db2_db2inst1_db2inst1_HADRDB-rs%'" 
4) repeat steps 2 and 3 for every affected HADR database, where 
HADRDB is the database name 
5) rgreq -o unlock db2_db2inst1_db2inst1_HADRDB-rg 
6) repeat step 5 for every HADR database, where HADRDB is the 
database name 
 
After having followed these instructions, the resource model as 
shown by "lssam -V" should now look like this: 
 
Online IBM.ResourceGroup:db2_db2inst1_host03_0-rg Nominal=Online 
 
        '- Online IBM.Application:db2_db2inst1_host03_0-rs 
-. 
                '- Online 
IBM.Application:db2_db2inst1_host03_0-rs:host03          | 
Online IBM.ResourceGroup:db2_db2inst1_host04_0-rg Nominal=Online 
| 
        '- Online IBM.Application:db2_db2inst1_host04_0-rs 
| -. 
                '- Online 
IBM.Application:db2_db2inst1_host04_0-rs:host04          |  | 
Online IBM.ResourceGroup:db2_db2inst1_db2inst1_HADRDB-rg 
Nominal=Online            |  | 
        '- Online 
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs 
|  | 
                |- Online 
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:host03   |  | 
                '- Offline 
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:host04  |  | 
Online IBM.Equivalency:db2_db2inst1_host03_0-rg_group-equ 
|  | 
        '- Online IBM.PeerNode:host03:host03 
|  | 
Online IBM.Equivalency:db2_db2inst1_host04_0-rg_group-equ 
|  | 
        '- Online IBM.PeerNode:host04:host04 
|  | 
Online IBM.Equivalency:db2_db2inst1_db2inst1_HADRDB-rg_group-equ 
|  | 
        |- Online IBM.PeerNode:host04:host04 
|  | 
        '- Online IBM.PeerNode:host03:host03 
DO  | 
Online IBM.Equivalency:db2_public_network_0 
<'  | 
        '- Online IBM.NetworkInterface:eth0:host03 
DO 
Online IBM.Equivalency:db2_public_network_1 
<' 
        '- Online IBM.NetworkInterface:eth1:host04 
 
 
Issuing a takeover HADR command after this, should now succeed.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 HADR/HA users                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1.0.5                              * 
****************************************************************
Local-Fix:
Manually delete HADR dependencies against the public network 
equivalency grouping. See Error Description for more details.
Lösung
Fixed in DB2 version 10.1.0.5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

09.07.2014
14.07.2015
14.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)


Problem behoben lt. FixList in der Version


10.1.0.5

FixList