Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2011
    Location
    Mumbai,India
    Posts
    49

    Unanswered: Db2 hadr functionality

    Hi,

    DB2 V9.5 FP5 , OS : AIX 6.1

    We have setup HADR on it. HADR_MODE : ASYNC.
    We noticed that when standby goes down everything work properly on primary. but once we restart primary database then we are not allowed to connect to database until and unless either we force start HADR on primary or we shut down HADR on primary.

    Is there any mode or any way so that we can avoid this behaviour??

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    but once we restart primary database : you mean activate ?
    what is going down on standby : instance - hadr ??
    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

  3. #3
    Join Date
    Aug 2011
    Location
    Mumbai,India
    Posts
    49
    Yes i mean activate. i.e when u try to connect to db.

    SAN @standby went down.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    can you specify in more detail the timing of the events as
    We noticed that when standby goes down everything work properly on primary. but once we restart primary database..
    this is not very clear : standby down-primary restarted ??
    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

  5. #5
    Join Date
    Aug 2011
    Location
    Mumbai,India
    Posts
    49
    1) We had a HADR setup. and it was working fine.
    2) One day accidently SAN @standby went down. and we didnt came to know about this.
    3) Every day from 2 AM to 7 AM we get a maintainance window in which we take cold backup of database. and other teams take system backup.
    4) At time of cold backup we deactivate database. all this maintainance is done by scripts.
    5) Next day users were not able to connect to database.
    6) So for that period of time we have shut down HADR and everything started working properly.

    Later we did UAT and came to know that if u r standby is down and primary is active then it will not create any impact on primary. But once primary is deactivated (when standby is not available) then to activae primary next time either we have to shut down HADR or force start primary in HADR environment.

  6. #6
    Join Date
    Nov 2011
    Posts
    8
    When the primary server is first started, it waits for the standby server to contact it. If the standby server does not make contact with the primary after a specific period of time(HADR_TIMEOUT), HADR will not start.

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    usually you start first hadr on standby (listener) and next the primary that will connect to primary.. if connection is lost (after timeout) hadr is disconnected..
    when connection is available hadr will restart again
    check status before doing anything db2pd -d xxx -hadr
    we monitor all the time the status.. and ship mail if disconnected..
    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
  •