Results 1 to 2 of 2

Thread: Hadr issue

  1. #1
    Join Date
    Apr 2015
    Posts
    13

    Unanswered: Hadr issue

    Hi All,

    Im using DB2 10.1 and want to setup HADR for 14 DB's present on 1 server. I Successfully implemented HADR for 1 DB and also tested it.
    It's working fine.

    But when I'm trying to configure hadr for remaining DB's by following same procedure as I followed for 1st DB it is not working for me.

    I'm getting below error in diaglog
    --------------------------------------------

    2015-06-08-14.48.08.441717+330 I7315851E561 LEVEL: Warning
    PID : 11416 TID : 139778242635520 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: xxx
    EDUID : 85 EDUNAME: db2hadrp.0.1 (DB2) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrBindAndListen, probe:20310
    MESSAGE : ZRC=0x810F001B=-2129723365=SQLO_ADDR_IN_USE "Address already in use"
    DATA #1 : String, 45 bytes
    Retrying bind, socket is in use. Retry count:
    DATA #2 : unsigned integer, 8 bytes
    5

    2015-06-08-14.48.08.942137+330 I7316413E448 LEVEL: Error
    PID : 11416 TID : 139778242635520 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: xxx
    EDUID : 85 EDUNAME: db2hadrp.0.1 (DB2) 0
    FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrBindAndListen, probe:20320
    MESSAGE : ZRC=0x810F001B=-2129723365=SQLO_ADDR_IN_USE "Address already in use"


    What might be the reason behind this.. Can't I use same port number for other DB's ???

    If not then what is the other solution for this..

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    hadr_local_svc is a db cfg setting and must be unique by db
    details at : http://www-01.ibm.com/support/knowle...=SSEPGG_10.1.0
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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