home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC99809 Status: Closed

VARIOUS DB2HAICU OPERATIONS FAILING IN A CONFIGURATION CONTAINING 50 OR
MORE HIGHLY AVAILABLE HADR DATABASES

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
In a db2haicu HADR configuration containing 50 or more highly 
available HADR databases, various db2haicu operations may fail. 
The db2haicu operations that are affected by this issue are the 
following: 
 
1. Create/delete HADR database 
2. Create HADR Virtual IP address 
3. "db2haicu -disable" 
4. "db2haicu -delete" 
5. db2haicu move option in maintenance mode 
 
In the event that this issue is reproduced, the following two 
db2diag.log messages should be seen when having the DIAGLEVEL 
dbm cfg parameter set to 4: 
 
2014-01-29-11.48.48.882133-300 I88355E371          LEVEL: Info 
PID     : 7762                 TID  : 140737352730368PROC : 
db2haicu 
INSTANCE: db2inst2             NODE : 000 
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, 
sqlhaGetObjectNames, probe:300 
MESSAGE : Read number of HA resource objects for 
GetObjectNames() 
DATA #1 : unsigned integer, 4 bytes 
112 
 
2014-01-29-11.48.48.882278-300 E88727E358          LEVEL: Error 
PID     : 7762                 TID  : 140737352730368PROC : 
db2haicu 
INSTANCE: db2inst2             NODE : 000 
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, 
sqlhaListHADR, probe:90 
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR 
          Error reported from Cluster 
 
If the value in the data field of the first db2diag.log message 
is greater than or equal to 100 than it confirms this issue. 
 
The following error prompt message is returned from db2haicu: 
 
There was an error with one of the issued cluster manager 
commands. 
Refer to db2diag.log and the DB2 Information Center for details.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 HADR/TSA users                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.5.0.4                                     * 
****************************************************************
Local Fix:
N/A
available fix packs:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Solution
Fixed in DB2 V10.5.0.4
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.03.2014
08.09.2014
08.09.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.4 FixList