Results 1 to 2 of 2

Thread: hadr standby

  1. #1
    Join Date
    Apr 2006
    Provided Answers: 11

    Unanswered: hadr standby

    we have db2 ese on p/linux 9.5 fp8
    we are using hadr and tsa in an instance with many db's
    we wanted to apply some maintenance
    applied the maintenance on standby server first. - ok
    now doing a takeover on all databases to free the primary server
    at that time (while takeover running) I was disconnected from vpn and lost connection with these machines
    after logon again we stated 1 database on both servers in standby mode
    I tried all kind of commands - stop hadr - deactivate - takeover force to try to release one of these db - no success
    finally I dropped the db and restored db with rollforward
    I could see in another pmr a similar situation but they don't provide much detail

    has anybody lived such a scenario and how did you get out of this ?
    can a rollforward be executed (after you can stop hadr I presume) ?

    this was the text from the other pmr
    I had the customer try and connect to the "primary" database and it said
    it was still in HADR standby mode. I had the customer stop HADR on the
    primary, deactivate the database, stop HADR on the "standby" and then
    activate the "primary". He had to rollforward through the logs to get
    it to deactivate but was able to do so. He deactivated successfully,
    stopped HADR, the activated the database and is able to connect without
    further issue.

    any idea/help is welcome - many thanks ..
    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    You can view pmrs opened by other customers? I tried "Search for service requests" opened by all customers, but it seems I can only see pmrs opened by my customer #

Posting Permissions

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