|
Problem IC66723
|
Status: Closed |
DB2HAICU CANNOT HANDLE EXISTING FIXED TSA RESOURCES AND EXIT WITH ERROR. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
When using db2haicu to setup cluster resources, you may see the
following error:
Customer is trying to set up HADR resources using db2haicu. It
run fine on Standby but error out on Primary:
Do you want to validate and automate HADR failover for the HADR
database HADB? [1]
1. Yes
2. No
1
Adding HADR database HADB to the domain ...
There was an error with one of the issued cluster manager
commands. Refer to db2diag.log and the DB2
Information Center for details
db2diag.log shows this error:
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
sqlhaListGroupsOnlineAtNode, probe:1400
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
Error reported from Cluster
This will happen if there are already existing resources
(IBM.Application resources with ResourceType == 0)
on the cluster that were originally created outside of db2haicu.
The problem is due to db2haicu not handling
these resources properly. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* When using db2haicu to setup cluster resources, you may *
* seethefollowing error:Customer is trying to set up HADR *
* resources using db2haicu.Itrun fine on Standby but error out *
* on Primary:Do you want to validate and automate HADR *
* failover for theHADRdatabase HADB? [1]1. Yes2. No1Adding *
* HADR database HADB to the domain ...There was an error with *
* one of the issued cluster managercommands. Refer to *
* db2diag.log and the DB2Information Center for *
* detailsdb2diag.log shows this error:FUNCTION: DB2 Common, *
* SQLHA APIs for DB2 HA *
* Infrastructure,sqlhaListGroupsOnlineAtNode, *
* probe:1400RETCODE : *
* ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERRORError *
* reported from ClusterThis will happen if there are already *
* existing resources(IBM.Application resources with *
* ResourceType == 0)on the cluster that were originally *
* created outside ofdb2haicu.The problem is due to db2haicu *
* not handlingthese resources properly. *
****************************************************************
* RECOMMENDATION: *
* upgrade to version 9.5 Fp6 or later *
**************************************************************** |
| Local Fix: |
Use db2haicu to create the DB2 resources first before
creating the fixed resources through other means. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
first fixed in V9.5v FP6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC66733 IC66736
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.03.2010
12.11.2010
12.11.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP6,
9.5.V
|
| Problem solved according to the fixlist(s) of the following version(s) |
