SAP Knowledge Base Article - Preview

2639066 - SQL1768N Unable to start HADR, Reason Code 7

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 with DB2 Universal Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.