On Mon, May 16, 2011 at 12:31 PM, David Gibbs wrote:
If you write to a *DTAARA the system forces the write to disk.
Now if you have write cache on your disk controllers the write to
that cache is considered 'well enough' and processing continues.
However if you have no cache (as a low end system with mirrored
disk might have) then the write must be actually to disk.
My perspective on using data areas is that they should be read
mostly / update rarely.
I've never seen them that way....consider that IBM themselves use
data areas to support SQL sequence columns....
It wouldn't seem to make sense to do so if Larry's correct about the
overhead of writing to them.