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 when attempting to connect to itself via hostname.

For the record, /etc/hosts should look similar to this: -   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6 bpm856.uk.ibm.com bpm856 db2one.uk.ibm.com db2one db2two.uk.ibm.com db2two

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

No comments: