Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: Communication with HADR partner was lost

    hi all,
    i found following error in diaglog

    2012-04-23-00.00.56.012000+330 I77491893F437 LEVEL: Severe
    PID : 4732 TID : 4164 PROC : db2syscs.exe
    INSTANCE: DB2PRD NODE : 000
    EDUID : 4164 EDUNAME: db2hadrp (PRD) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduAcceptEvent, probe:20215
    RETCODE : ZRC=0x8280001B=-2105540581=HDR_ZRC_COMM_CLOSED
    "Communication with HADR partner was lost

    db2pd HADR Information:
    Role State SyncMode HeartBeatsMissed LogGapRunAvg (bytes)
    Primary Disconnected Nearsync 0 5274643538


    now simply starting HADR secondary and primary will solve my issue or i have to restore latest database backup on standby ( i am asking this because loggap is 5274643538 bytes)

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Please post output of this:

    db2pd -d <your-database> -hadr
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Dec 2010
    Posts
    123
    Quote Originally Posted by Marcus_A View Post
    Please post output of this:

    db2pd -d <your-database> -hadr
    hi marcus i already mentioned that info in above quote only, once again please find the info as follows


    HADR Information:
    Role State SyncMode HeartBeatsMissed LogGapRunAvg (bytes)
    Primary Disconnected Nearsync 0 5274643538

    ConnectStatus ConnectTime Timeout
    Disconnected Mon Apr 23 00:00:55 2012 (1335119455) 120

    PeerWindowEnd PeerWindow
    Null (0) 120

    LocalHost LocalService
    192.168.82.143 55001

    RemoteHost RemoteService RemoteInstance
    192.168.82.151 55002 DB2

    PrimaryFile PrimaryPg PrimaryLSN
    S0010445.LOG 1212 0x000000C3492D3575

    StandByFile StandByPg StandByLSN
    S0010585.LOG 16379 0x000000C20E806BE8

  4. #4
    Join Date
    Jul 2004
    Posts
    306
    It depends why they are disconnected.... What does db2pd say about hadr on the standby?

    You can try restarting HADR and see what errors you get if any... are you sure the connection is up?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •