Symptom
HADR Standy failed to start and the following information can be found in the db2diag.log of the standby system:
2020-02-17-12.59.20.895488+330 I199926966E488 LEVEL: Info
PID : 12345 TID : 123456789123456 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-1234 APPID: *LOCAL.db2abc.123456789123
AUTHID : DB2ABC HOSTNAME: HOSTNAME
EDUID : 1234 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21151
MESSAGE : HADR Startup has begun.
2020-02-17-12.59.20.958224+330 I199928195E536 LEVEL: Error
PID : 12345 TID : 123456789123456 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-1234 APPID: *LOCAL.db2abc.123456789123
AUTHID : DB2ABC HOSTNAME: HOSTNAME
EDUID : 1234 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrResolveHostNameAndPort, probe:1540
MESSAGE : ZRC=0x810F0032=-2129723342=SQLO_HOST_UNKNOWN "Host unknown"
2020-02-17-12.59.20.961352+330 I199928732E623 LEVEL: Error
PID : 12345 TID : 123456789123456 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-1234 APPID: *LOCAL.db2abc.123456789123
AUTHID : DB2ABC HOSTNAME: HOSTNAME
EDUID : 1234 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrGetPortByName, probe:1100
MESSAGE : ZRC=0x070F00B8=118423736=SQLO_NOT_FOUND
"Environment/registry variable was not found."
DATA #1 : <preformatted>
Invalid input for port: servicename
2020-02-17-12.59.20.962530+330 E199931128E618 LEVEL: Error
PID : 12345 TID : 123456789123456 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-1234 APPID: *LOCAL.db2abc.123456789123
AUTHID : DB2ABC HOSTNAME: HOSTNAME
EDUID : 1234 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrResolveAllHostsAndSetIpProtocol, probe:25010
MESSAGE : ZRC=0x87800143=-2021654205=HDR_ZRC_CONFIG_REMOTE_SVC
"HADR_REMOTE_SVC configuration parameter is an invalid service name"
2020-02-17-12.59.20.963141+330 I199933383E563 LEVEL: Error
PID : 12345 TID : 123456789123456 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-1234 APPID: *LOCAL.db2abc.123456789123
AUTHID : DB2ABC HOSTNAME: HOSTNAME
EDUID : 1234 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21180
MESSAGE : SQL1768N Unable to start HADR. Reason code = "6".
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
0x87800143
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
HADR_REMOTE_SVC, /etc/services, invalid input for port, invalid service name, HADR, standby , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview