Page 1 of 1

buffer cleanup on exit?

Posted: Thu Jan 19, 2012 9:53 pm
by ghosttie
I noticed lines like this in my jommsg.log:
2012/01/19 09:45:21.075 028f0-3c44 TDB: buffer cache: 2097152 byte heap, buffer cleanup on exit disabled (default), hash modulus = 2042
Any idea what it's talking about? I couldn't find a reference to it in the help files.

Re: buffer cleanup on exit?

Posted: Fri Jan 20, 2012 7:35 am
by GerardO'Brien
It was found that process termination could take an awfully long time when database caches were very large in a 64 bit database server. Traversing the buffer pool and verifying the state of the buffers didn't cost much but cleanup, that is removing each buffer from control structures (list management etc), adjusting and checking accounting, and releasing each buffer back to the system (heap delete), was quite costly and was observed in some instances to add tens of minutes to shutdown times.

The operating system reclaims all resources when the process terminates so buffer pool (transient and persistent) finalise was changed to only perform state verification.