After-image enabled UNBUFFERED. (845)

[Bill Burke]

I found this message in the db log

"After-image enabled UNBUFFERED. (845)"

Looking through the online doc, I could only find how to change this to BUFFERED using the CHANGE qualifier.

I cannot find any detailed information on what this is, and the benefits of being Buffered or Unbuffered.

Can anyone offer some insight?

Thanks in advance.

Bill

 

[Norman Biggar]

Found this in 8.2 documentation. Hope it helps

buffered (UNIX and NT)
Indicates that writes to the after-image (AI) file are buffered, providing increased performance. However, if after a system crash you must reconstruct the database from the AI file, you might lose transactions completed during the two minutes that preceded the crash. These lost transactions do not affect the structural integrity of your database.

unbuffered(UNIX and NT)
Indicates that the writes to the AI file are not buffered, providing lower performance than with buffered AI writes. However, if after a system crash you have to reconstruct the database from the AI file, you will retain all transactions that were completed up to the crash.

So, How lucky do you feel?

 

[Bill Burke]

Originally posted by Norman Biggar

So, How lucky do you feel?

Thanks, Norm!

Very informative.

Oh....I think we'll be keeping it UNbuffered.