DB2 - Problem description
| Problem IT09278 | Status: Closed |
RUNNING DB2HAICU IN XML MODE TO SETUP A SECOND HADR DATABASE FOR HIGH AVAILABILITY RETURNS AN ERROR | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
Running db2haicu in XML mode to setup a second HADR database for
high availability for the same instance causes the following
error message to be displayed:
Adding DB2 database partition '0' to the cluster ...
Creating dependency failed. Refer to db2diag.log for the current
member and the DB2 Information Center for details.
There was an internal db2cluster error. Refer to the diagnostic
logs (db2diag.log or /tmp/ibm.db2.cluster.*) and the DB2
Information Center for details.
In addition to this, the following db2diag.log error message is
seen:
2014-06-23-20.41.10.723339-300 E1577489E785 LEVEL:
Error
PID : 11376 TID : 140721547073312 PROC :
db2haicu
INSTANCE: db2inst1 NODE : 000
HOSTNAME: host02
FUNCTION: DB2 UDB, high avail services, sqlhaAddResourceGroup2,
probe:300
MESSAGE :
ECF=0x90000545=-1879046843=ECF_SQLHA_CREATE_DEPENDENCY_FAILED
Add dependency failed
DATA #1 : String, 35 bytes
Error during vendor call invocation
DATA #2 : unsigned integer, 4 bytes
28
DATA #3 : String, 27 bytes
db2_db2inst1_host02_0-rg
DATA #4 : unsigned integer, 4 bytes
1
DATA #5 : unsigned integer, 8 bytes
1
DATA #6 : signed integer, 4 bytes
200
DATA #7 : String, 109 bytes
Line # : 6886---2621-200 Equivalency name
"db2_db2inst1_host02_0-rg_group-equ" already defined.
; FFDC ID:
This is due to the fact that the DB2 database partition resource
for the instance already exists. Currently we fail with the
above error in this case, but db2haicu should instead identify
that the DB2 partition resource already exists and continue on
to create the HADR resource. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 and Fix Pack 7 * **************************************************************** | |
| Local Fix: | |
Setup the HADR database for high availability by running db2haicu in interactive mode. | |
| Solution | |
Problem was first fixed in DB2 Version 10.5 and Fix Pack 7 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.06.2015 19.01.2016 28.04.2016 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.7 |
|