|
Problem IC64856
|
Status: Closed |
DB2HAICU FAILS AT THE END OF THE SETUP ON PRIMARY. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If an instance name contains underscores (_) like 'dba_hadr',
then db2haicu will fail at the end of the setup on primary.
db2haicu will not fail on the standby side. This is because
db2haicu relies on "_" as the delimiter for all the resource
names. lssam will show both primary and standby resource groups
but not an HADR resource group, it fails while creating one.
Sample db2haicu interactive mode output:
...
Adding HADR database DBA_HADR to the domain ...
The HADR database TESTDB cannot be added to the cluster because
the standby instance is not configured in the domain. Run
db2haicu on the standby instance to configure it into the
cluster.
All cluster configurations have been completed successfully.
db2haicu exiting ...
In db2diag.log, you will see a message like this:
2009-08-19-10.00.52.138860-300 E5618A591 LEVEL: Error
PID : 421924 TID : 1 PROC :
db2haicu
INSTANCE: dba_hadr NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
sqlhaUICreateHADR, probe:900
RETCODE :
ECF=0x9000056F=-1879046801=ECF_SQLHA_HADR_VALIDATION_FAILED
The HADR DB failed validation before being added to
the cluster
DATA #1 : String, 8 bytes
dba_hadr
DATA #2 : String, 8 bytes
dba_hadr
DATA #3 : String, 8 bytes
amdha1
DATA #4 : String, 8 bytes
amdha2
DATA #5 : String, 8 bytes
TESTDB |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users on a cluster (HA) env *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2HAICU FAILS AT THE END OF THE SETUP ON PRIMARY. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 9.7 FP2 *
**************************************************************** |
| Local Fix: |
Either create a new instance name or change the existing
instance name such that it does not contain any underscore, and
recatalog the database on both primary and standby. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
DB2HAICU FAILS AT THE END OF THE SETUP ON PRIMARY. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.11.2009
25.05.2010
25.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
