Tuesday, 15 December 2015

Reminder - DB2 HADR and SQL1768N rc7

Reminder to self: -

If I see SQL1768N rc7 when attempting to use DB2 HADR, there's a good chance that I've forgotten to update /etc/hosts meaning that one/both hosts is returning the loopback / localhost address of 127.0.0.1 when attempting to connect to itself via hostname.

For the record, /etc/hosts should look similar to this: -

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.153.100 bpm856.uk.ibm.com bpm856
192.168.153.110 db2one.uk.ibm.com db2one
192.168.153.120 db2two.uk.ibm.com db2two

In other words, there must be no other hostname alongside the localhost entries.

No comments: