Re: DataArea vs. Tables

[Charles Wilt <charles.wilt@xxxxxxxxx>]

On Mon, May 16, 2011 at 12:31 PM, David Gibbs <david@xxxxxxxxxxxx> wrote:
> DrFranken 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.

Charles