Re: Tuning for rollbacks?

renny_at_eircom.net wrote:
> Hi Sybrand,>> Thanks for the response.>> > This should explain why a rollback is 'slower' and why your method is> > very strange.>> Yes, I agree what we're doing with our test suite is a perverse use of> a database - from your reply it would seem that the slow performance of> rollbacks compared to commits is something we'll have to live with.>> Kind regards,;>> Renny

For DB2 you can increase the size of the LOGBUFSZ (the log buffer). I
would set it to 256 or 512 pages for an OLTP application even if you
were not doing a lot of rollbacks. This memory comes out of the DBHEAP,
so you will need to increase that by a corresponding amount (all other
things being equal).
Received on Thu Sep 15 2005 - 09:56:10 CDT