Troubleshooting
Problem
In a single standby setup start hard on primary will timeout with the following error db2 start hadr on db hadrdb as primary SQL1768N Unable to start HADR. Reason code = "7".
Cause
hadr_target_list is set in a single Standby setup
Diagnosing The Problem
Below message can be seen in the db2diag.log
MESSAGE : ADM12510E Unable to establish HADR primary-standby connection with
host: "hadr_target_list.". Reason code: "10"
Resolving The Problem
set hadr_target_list to NULL
db2 update db cfg for <database name> HADR_TARGET_LIST NULL
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"HADR - Setup","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg22004009