Symptom
- HADR Primary is failed to establish connection with standby and throw below error in db2diag.log
2018-04-06-13.52.06.290846+120 I81285178A561 LEVEL: Error
PID : ********* TID : ********** PROC : db2sysc 0
INSTANCE: db2*** NODE : 000 DB : ***
APPHDL : 0-27413 APPID: *LOCAL *********************
AUTHID : DB2*** HOSTNAME: *****************
EDUID : ******* EDUNAME: db2agent (***) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21250
MESSAGE : SQL1768N Unable to start HADR. Reason code = "7". - 2018-04-06-13.52.06.316564+120 E81285740A2480 LEVEL: Event
PID : ********* TID : ********** PROC : db2sysc 0
INSTANCE: db2*** NODE : 000 DB : ***
APPHDL : 0-27413 APPID: *LOCAL *********************
AUTHID : DB2*** HOSTNAME: *****************
EDUID : ******* EDUNAME: db2agent (***) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetDbRoleAndDbType, probe:10020
CHANGE : HADR DATABASE ROLE/TYPE -
HADR database role set to STANDARD (was PRIMARY).
HADR database type set to NONE (was PHYSICAL).
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000038F76EBC hdrSetDbRoleAndDbType__FP9SQLP_DBCBCUiT2 + 0x1530
[1] 0x090000003A396C94 hdrUndoDbRoleIfNecessary__FP14sqlpMasterDbcbCUiT2 + 0x254
[2] 0x090000003A8B1DD8 hdrEduStartup__FP16sqeLocalDatabaseP9sqeBsuEduP14sqlpMasterDbcbCbCUiT4C19hdrEduStartupActionP5sqlcaT4 + 0x3D0
[3] 0x090000003ADE59B8 sqlpCheckToStartHadr__FP8sqeAgentP16sqeLocalDatabaseP5sqlcabUiPbT4 + 0x36C
[4] 0x090000003ADEED9C sqlpCheckToStartHadr__FP8sqeAgentP16sqeLocalDatabaseP5sqlcabUiPbT4 + 0x4C8
[5] 0x090000003A938954 AppStartUsing__14sqeApplicationFP8SQLE_BWAP8sqeAgentcT3P5sqlcaPc + 0x1388
[6] 0x090000003CCB8E14 AppLocalStart__14sqeApplicationFP14db2UCinterface + 0x53C
[7] 0x090000003CCB8854 sqlelostWrp__FP14db2UCinterface + 0x44
[8] 0x090000003B1CBC80 sqleUCengnInit__FP14db2UCinterfaceUs + 0x268
[9] 0x090000003CCCA888 sqleUCagentConnect + 0x420
[10] 0x090000003CCC79F4 sqljsConnectAttach__FP13sqljsDrdaAsCbP14db2UCinterface + 0x750
[11] 0x090000003CCC648C sqljs_ddm_accsec__FP14db2UCinterfaceP13sqljDDMObject + 0x32C
[12] 0x090000003CCC5F34 sqljsParseConnect__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x4C
[13] 0x090000003B1E3354 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1130
[14] 0x090000003B1E2F48 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xD24
[15] 0x090000003A9D7988 @72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
[16] 0x090000003A9D849C @72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5FC
[17] 0x090000003C836A88 RunEDU__8sqeAgentFv + 0x40618
[18] 0x090000003C869974 RunEDU__8sqeAgentFv + 0x11C
[19] 0x090000003BE56364 EDUDriver__9sqzEDUObjFv + 0x130
[20] 0x090000003C402498 sqloEDUEntry + 0x394
[21] 0x090000000054CE10 _pthread_body + 0xF0
[22] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
Read more...
Environment
- Db2 LUW 9.7 and above
- SAP NETWEAVER 7.5 / 701
- SAP SOLUTION MANAGER 7.1
- SAP ERP 6.0
Product
SAP ERP 6.0 ; SAP NetWeaver 7.5 ; SAP Solution Manager 7.1
Keywords
HADR, HADR_TIMEOUT, hadr_peer_window, Connection , KBA , BC-DB-DB6-DBA , Database Administration , 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.