Connecting Tech Pros Worldwide Forums | Help | Site Map

DB2_USE_ALTERNATE_PAGE_CLEANING and HADR

Mark A
Guest
 
Posts: n/a
#1: Nov 3 '08
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?



Serge Rielau
Guest
 
Posts: n/a
#2: Nov 3 '08

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
Mark A
Guest
 
Posts: n/a
#3: Nov 3 '08

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.


Serge Rielau
Guest
 
Posts: n/a
#4: Nov 3 '08

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