DB2 - Problem description
Problem IT36226 | Status: Closed |
FAILURE TO BIND PORT DURING DB2START MAY RESULT IN SUCCESSFUL DB2START AND BLOCK FAILOVER IN HADR ENVIRONMENT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
In a HADR environment in an instance down scenario where an instance restart is attempted, the db2start triggered during recovery may encounter a port binding failure. This port binding failure may result in a successful instance start up, however, the started Db2 may not be able to communicate with applications. This resulting started instance may fail to handle application results and may block a failover from happening. The following may be seen in the db2diag.log: 2020-07-07-20.10.38.824727+180 I108340486E386 LEVEL: Error PID : 29034 TID : 47204559480576 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 HOSTNAME: EDUID : 1 EDUNAME: db2sysc 0 FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr, probe:47 MESSAGE : DIA3202C The TCP/IP call "bind" returned an errno="22". | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 systems in an HADR environment prior to Db2 version * * 11.1.4.6 or 11.5.5.0 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.1.4.6 or 11.5.5.0 * **************************************************************** | |
Local Fix: | |
Issue a manual takeover or restart the affected instance. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Db2 systems in an HADR environment prior to Db2 version * * 11.1.4.6 or 11.5.5.0 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.1.4.6 or 11.5.5.0 * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.03.2021 15.03.2021 15.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |