Re: heavy inserts and bufferpool

<dcruncher4@[EMAIL PROTECTED]
> wrote in message news:fui7er03bt@[EMAIL PROTECTED]
> In article <dSOOj.28633$Q52.8397@[EMAIL PROTECTED]
>, Mark A says...
>
>>db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON (this will override
>>CHNGPGS_THRESH)
>>db2set DB2_SKIPINSERTED=ON (this will reduce lock contention on inserts)
>>db2 update db cfg for test using NUM_IOCLEANERS 8
>>db2 update db cfg for test using LOGBUFSZ 256
>>db2 update db cfg for test using DBHEAP 2000 (unless it already at least
>>this high)
>
> I did it and it works. I still get this error but very rarely.
> per a db2 dba, it is this which solved my problem.
>
> db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON
>
> I am going to test it again with everything at default setting,
> and then set the above.

You probably don't want to use the default setting of 8 for LOGBUFSZ (at 
least that was the default before version 9.5). For your high insert
volume 
application 256 should work better (and the LOGBUFSZ comes out of DBHEAP
so 
that needs to be increased by the same amount). I would also go with 
NUM_IOCLEANERS of 8 or automatic. 3 is probably too low.

But I agree that for your symptoms, DB2_USE_ALTERNATE_PAGE_CLEANING=ON
makes 
the biggest difference.

Unless something is set to automatic from a fresh database create using
DB2 
9.5 (instead of an upgrade of database from a previous release), the 
defaults are usually suspect, since many of them have not changed in about

10 years or more.