Connecting Tech Pros Worldwide Help | Site Map

DB2_USE_ALTERNATE_PAGE_CLEANING and HADR

  #1  
Old November 3rd, 2008, 12:35 PM
Mark A
Guest
 
Posts: n/a
On an application with a very high volume of inserts, is there any reason
not to set DB2_USE_ALTERNATE_PAGE_CLEANING=ON for a system that is running
HADR?


  #2  
Old November 3rd, 2008, 02:45 PM
Serge Rielau
Guest
 
Posts: n/a

re: DB2_USE_ALTERNATE_PAGE_CLEANING and HADR


Mark A wrote:
Quote:
On an application with a very high volume of inserts, is there any reason
not to set DB2_USE_ALTERNATE_PAGE_CLEANING=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
  #3  
Old November 3rd, 2008, 06:05 PM
Mark A
Guest
 
Posts: n/a

re: DB2_USE_ALTERNATE_PAGE_CLEANING and HADR


"Serge Rielau" <srielau@ca.ibm.comwrote in message
news:6n8gk1Fjvs9eU1@mid.individual.net...
Quote:
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.


  #4  
Old November 3rd, 2008, 08:25 PM
Serge Rielau
Guest
 
Posts: n/a

re: DB2_USE_ALTERNATE_PAGE_CLEANING and HADR


Mark A wrote:
Quote:
"Serge Rielau" <srielau@ca.ibm.comwrote in message
news:6n8gk1Fjvs9eU1@mid.individual.net...
Quote:
>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
Closed Thread