DB2 - Problem description
| Problem IC96985 | Status: Closed |
In a pureScale HADR system, hosts configured with full length IP addresses will fail to form a pair with remote database. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
In a pureScale HADR system when the HADR hosts are conifgured
with a full length IP address like 192.168.142.101 will fail to
form a connection with the remote HADR database.
Messages similar to following might show up in the db2diag.log
2013-10-12-19.26.33.793489-240 I142495E595 LEVEL: Error
PID : 5613 TID : 139640405223168 PROC : db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB : testdb
HOSTNAME: node02
EDUID : 140 EDUNAME: db2hadrp.1.1 (testdb) 1
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrWeakCheckIpAddress, probe:76030
DATA #1 : <preformatted>
No host info was found in the discovery member info
192.168.140.104:57777|192.168.140.103:57777 matching the host
info in the local HADR_TARGET_LIST
{192.168.140.103:57777|192.168.140.104:57777}
2013-10-12-19.26.33.793896-240 I143091E517 LEVEL: Warning
PID : 5613 TID : 139640405223168 PROC : db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB : testdb
HOSTNAME: node02
EDUID : 140 EDUNAME: db2hadrp.1.1 (testdb) 1
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrEdu::hdrEduP, probe:76940
DATA #1 : <preformatted>
Rejecting connection from standby because no host address on the
standby cluster matches any host address on target list | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users using HADR * **************************************************************** * PROBLEM DESCRIPTION: * * Please see Error Description to find the details. * **************************************************************** * RECOMMENDATION: * * Users can upgrade to DB2 Version 10.5 fix pack 3 or higher * * to avoid this defect * **************************************************************** | |
| Local Fix: | |
Configure the HADR host with an IP address such that the total length is less than 15 characters. An example would be 192.168.142.10 . | |
| available fix packs: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
| Solution | |
First fixed in DB2 Version 10.5 fix pack 3 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.10.2013 27.02.2014 27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.3 |
|
| 10.5.0.3 |
|