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