HADR Status

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • lfhenry
    #1

    HADR Status

    Hi,
    If i have HADR setup with data synch setting of NEAR-SYNC and i have
    congestion on the line. Do my transactions block until the my
    HADR_STATE goes to PEER.
    In the instances that sometimes i have congestion,i have not noticed
    transactions waiting at all.
    This seems contrary to the idea of NEAR-SYNC, can anybody explain
    this?
    Tags: None
    • Mark A
      #2
      Re: HADR Status

      "lfhenry" <lfhenry@gmail. comwrote in message
      news:6128691a-2015-49b3-8346-8a1491abde62@s9 g2000prm.google groups.com...
      Hi,
      If i have HADR setup with data synch setting of NEAR-SYNC and i have
      congestion on the line. Do my transactions block until the my
      HADR_STATE goes to PEER.
      In the instances that sometimes i have congestion,i have not noticed
      transactions waiting at all.
      This seems contrary to the idea of NEAR-SYNC, can anybody explain
      this?
      Once HADR goes into anything other than peer state, it will not wait any
      longer, and will catch-up later. Of course, it is no longer in true
      near-synch if that happens (until it goes back to peer state). There is a
      time out parameter that you can set as to how long it will wait before going
      out of peer state.


        Comment

        • db2green
          #3
          Re: HADR Status

          On Oct 15, 12:33 pm, "Mark A" <some...@someon e.comwrote:
          "lfhenry" <lfhe...@gmail. comwrote in message
          >
          news:6128691a-2015-49b3-8346-8a1491abde62@s9 g2000prm.google groups.com...
          >
          Hi,
          If i have HADR setup with data synch setting of NEAR-SYNC and i have
          congestion on the line. Do my transactions block until the my
          HADR_STATE goes to PEER.
          In the instances that sometimes i have congestion,i have not noticed
          transactions waiting at all.
          This seems contrary to the idea of NEAR-SYNC, can anybody explain
          this?
          >
          Once HADR goes into anything other than peer state, it will not wait any
          longer, and will catch-up later. Of course, it is no longer in true
          near-synch if that happens (until it goes back to peer state). There is a
          time out parameter that you can set as to how long it will wait before going
          out of peer state.
          That really good info to know. thanks.

            Comment

            • db2green
              #4
              Re: HADR Status

              On Oct 15, 12:33 pm, "Mark A" <some...@someon e.comwrote:
              "lfhenry" <lfhe...@gmail. comwrote in message
              >
              news:6128691a-2015-49b3-8346-8a1491abde62@s9 g2000prm.google groups.com...
              >
              Hi,
              If i have HADR setup with data synch setting of NEAR-SYNC and i have
              congestion on the line. Do my transactions block until the my
              HADR_STATE goes to PEER.
              In the instances that sometimes i have congestion,i have not noticed
              transactions waiting at all.
              This seems contrary to the idea of NEAR-SYNC, can anybody explain
              this?
              >
              Once HADR goes into anything other than peer state, it will not wait any
              longer, and will catch-up later. Of course, it is no longer in true
              near-synch if that happens (until it goes back to peer state). There is a
              time out parameter that you can set as to how long it will wait before going
              out of peer state.
              That really good info to know. thanks.

                Comment

                Previous template Next
                Working...