Re: heavy inserts and bufferpool

[Serge Rielau]

dcruncher4@aim. com wrote:

update db cfg for test using CHNGPGS_THRESH 5 ;
update db cfg for test using NUM_IOCLEANERS 3 ;
update db cfg for test using NUM_IOSERVERS 3 ;

Have you tried just not touching these?
Here is the default setting I find on my laptop:
Changed pages threshold (CHNGPGS_THRESH ) = 80
Number of asynchronous page cleaners (NUM_IOCLEANERS ) = AUTOMATIC
Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC

Specifically note AUTOMATIC which means DB2 will take care of it.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Serge Rielau]

Re: heavy inserts and bufferpool

dcruncher4@aim. com wrote:

In article <6739rqF2n9jigU 2@mid.individua l.net>, Serge Rielau says...

>dcruncher4@aim. com wrote:

>>update db cfg for test using CHNGPGS_THRESH 5 ;
>>update db cfg for test using NUM_IOCLEANERS 3 ;
>>update db cfg for test using NUM_IOSERVERS 3 ;

>Have you tried just not touching these?
>Here is the default setting I find on my laptop:
> Changed pages threshold (CHNGPGS_THRESH ) = 80
> Number of asynchronous page cleaners (NUM_IOCLEANERS ) = AUTOMATIC
> Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC
>>
>Specifically note AUTOMATIC which means DB2 will take care of it.

>
well I started getting the problem even before I changed it.
In other words AUTOMATIC wasn't doing its job. I can test it
again by letting it being automatic and rerun my scripts.
Shall I contact you offline later on if the problem persists.
thanks.

Offline or here. Leave the alternate page cleaning proposed by Mark in
place though.
Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab