DB2_USE_ALTERNATE_PAGE_CLEANING and HADR

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

    DB2_USE_ALTERNATE_PAGE_CLEANING and HADR

    On an application with a very high volume of inserts, is there any reason
    not to set DB2_USE_ALTERNA TE_PAGE_CLEANIN G=ON for a system that is running
    HADR?


    Tags: None
    • Serge Rielau
      #2
      Re: DB2_USE_ALTERNA TE_PAGE_CLEANIN G and HADR

      Mark A wrote:
      On an application with a very high volume of inserts, is there any reason
      not to set DB2_USE_ALTERNA TE_PAGE_CLEANIN G=ON for a system that is running
      HADR?
      I fail to see the relationship. What are you thinking of?
      --
      Serge Rielau
      DB2 Solutions Development
      IBM Toronto Lab

        Comment

        • Mark A
          #3
          Re: DB2_USE_ALTERNA TE_PAGE_CLEANIN G and HADR

          "Serge Rielau" <srielau@ca.ibm .comwrote in message
          news:6n8gk1Fjvs 9eU1@mid.indivi dual.net...
          I fail to see the relationship. What are you thinking of?
          --
          Serge Rielau
          DB2 Solutions Development
          IBM Toronto Lab
          No relationship that I know of. I am a little suspicious as to why this is
          not the default.


            Comment

            • Serge Rielau
              #4
              Re: DB2_USE_ALTERNA TE_PAGE_CLEANIN G and HADR

              Mark A wrote:
              "Serge Rielau" <srielau@ca.ibm .comwrote in message
              news:6n8gk1Fjvs 9eU1@mid.indivi dual.net...
              >I fail to see the relationship. What are you thinking of?
              No relationship that I know of. I am a little suspicious as to why this is
              not the default.
              I think it will become the default over time, but there are still some
              workloads where the "old" page cleaners do better.
              Nothing to do with HADR though, I know that much.

              Cheers
              Serge

              --
              Serge Rielau
              DB2 Solutions Development
              IBM Toronto Lab

                Comment

                Previous template Next
                Working...