Re: Doubt on logical log - revisited

Posted in 2003

ART KAGEL, BLOOMBERG/ 65E — Wed, 19 Feb 2003 18:10:17 — source: IIUG Forums & Mailing Lists

I just checked the docs for 5.20, unlike the 9.3 doc (which is not specific) it says that logical log buffer flushes for UNBUFFERED databases are full page flushes often wasting the balance of a page when the transaction is small. So there IS indeed waste for UNBUFFERED logging (and in later releases for SET LOG sessions as well) for smaller transactions especially on 4K machines like AIX & WinXX. Art S. Kagel