Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Re: heavy inser...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 11 Topic 8805 of 9349
Post > Topic >>

Re: heavy inserts and bufferpool

by "Mark A" <nobody@[EMAIL PROTECTED] > Apr 21, 2008 at 09:09 PM

<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.
 




 11 Posts in Topic:
heavy inserts and bufferpool
dcruncher4@[EMAIL PROTECT  2008-04-20 01:39:45 
Re: heavy inserts and bufferpool
"Mark A" <no  2008-04-20 17:48:48 
Re: heavy inserts and bufferpool
dcruncher4@[EMAIL PROTECT  2008-04-21 07:13:47 
Re: heavy inserts and bufferpool
"Mark A" <no  2008-04-21 21:09:01 
Re: heavy inserts and bufferpool
dcruncher4@[EMAIL PROTECT  2008-04-22 06:14:49 
Re: heavy inserts and bufferpool
"Mark A" <no  2008-04-22 19:00:19 
Re: heavy inserts and bufferpool
"ajstorm@[EMAIL PROT  2008-04-23 06:12:16 
Re: heavy inserts and bufferpool
Serge Rielau <srielau@  2008-04-21 06:50:32 
Re: heavy inserts and bufferpool
dcruncher4@[EMAIL PROTECT  2008-04-21 07:10:33 
Re: heavy inserts and bufferpool
Serge Rielau <srielau@  2008-04-21 15:28:51 
Re: heavy inserts and bufferpool
Ian <ianbjor@[EMAIL PR  2008-04-21 22:50:45 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 6 15:24:13 CDT 2008.