|
Problem IT21424
|
Status: Closed |
THE PRIMARY HADR DATABASE FAILS OVER TO THE STANDBY AFTER CONFIGURING FOR HA VIA DB2HAICU. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When configuring an HADR database pair for HA via the db2haicu
utility, it is possible that the Primary HADR database role
fails over to the standby host shortly after db2haicu execution.
If this problem occurs and the following two db2diag.log
messages are seen on the original standby host, then it is a
match for this APAR:
2017-06-25-02.18.03.915829+720 E80421950E389 LEVEL: Info
PID : 2695 TID : 48009457543904 PROC :
db2gcf
INSTANCE: db2inst1 NODE : 000
HOSTNAME: hostB
FUNCTION: DB2 UDB, high avail services, sqlhaRemoveFlagRG,
probe:673
MESSAGE : Resource flag file has been deleted
DATA #1 : String, 49 bytes
db2_HADRDB_hostA_Reintegrate_db2inst1_db2inst1
2017-06-25-02.18.03.977507+720 E80422340E393 LEVEL: Info
PID : 2695 TID : 48009457543904 PROC :
db2gcf
INSTANCE: db2inst1 NODE : 000
HOSTNAME: hostB
FUNCTION: DB2 UDB, high avail services, sqlhaCreateFlagRG,
probe:508
MESSAGE : IBM.Test flag resource has been created
DATA #1 : String, 49 bytes
db2_HADRDB_hostA_Reintegrate_db2inst1_db2inst1
The root cause for this issue is the
'db2_HADRDB_hostA_Reintegrate_db2inst1_db2inst1' file being left
over in /tmp on the standby host. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 10.5 Fix Pack 9 or higher *
**************************************************************** |
| Local Fix: |
Before you run db2haicu to configure HA, first ensure that there
are no leftover flag files in /tmp on either host, i.e. run the
"ls /tmp | grep db2_<DBNAME>" command on both hosts and ensure
there are no files with this prefix. If there are, they must be
deleted. |
| Solution |
First fixed in Db2 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.07.2017
29.09.2017
29.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
