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 |