FCM problems related to 127.0.0.2 (Linux® and UNIX)

In a partitioned database environment, the fast communications manager (FCM) might encounter problems if there is an entry for 127.0.0.2 in the /etc/hosts file.

Symptoms

Various error messages might occur, depending on the circumstances. For example, the following error can occur when you create a database: SQL1229N The current transaction has been rolled back because of a system error. SQLSTATE=40504

Causes

The problem is caused by the presence of an entry for the IP address 127.0.0.2 in the /etc/hosts file, where 127.0.0.2 maps to the fully qualified hostname of the machine. For example:

127.0.0.2 ServerA.ibm.com ServerA

where "ServerA.ibm.com" is the fully qualified hostname.

Environment

The problem is limited to partitioned database environments.

Resolving the problem

Remove the entry from the /etc/hosts file, or convert it into a comment. For example:

# 127.0.0.2 ServerA.ibm.com ServerA