DB2 - Problem description
Problem IT03052 | Status: Closed |
RUNNING DB2HAICU IN XML MODE TO SETUP A SECOND HADR DATABASE FOR HIGH AVAILABILITY RETURNS AN ERROR | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - 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.1 and Fix Pack 5 * **************************************************************** | |
Local Fix: | |
Setup the HADR database for high availability by running db2haicu in interactive mode. | |
Solution | |
Problem was first fixed in DB2 Version 10.1 and Fix Pack 5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.07.2014 16.07.2015 16.07.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 |