From: Stan Sieler <[log in to unmask]>
>
> > If it is built/loaded during the same
> > open, NMKSAM will leave some ventilation space within its structures at
> > certain iterations.
>
> I'm not sure that it leaves ventilation holes.  The real reason it's
> faster is that the initial creation is done before the file is
> attached to the transaction manager (XM).  This means the XM overhead
> is bypassed.  If you create the file and then fill it later, the
> updates go through XM.

IIRC you can achieve the same results (detaching from XM) by making the KSAM
file a temporary file when you build it, then save the temporary file to
permanent after populating it. This would be akin to enabling autodefer on a
database.

Doug.

Doug Werth                             Beechglen Development Inc.
[log in to unmask]                               Cincinnati, Ohio

The opinions expressed do not  necessarily represent the views or
opinions of Beechglen Development. They might but not necessarily.
They represent solely the opinions of the author.