Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic



A default behavior permits a variable-length record that grows to grow in place if (a) the record is at the Logical End of File (LEOF), (b) no other user is adding a record at the LEOF, and (c) the growth of the record does not exceed the current Physical End of File (PEOF). Additional behavior (default) removes the limitation that the record growth stay within the current PEOF.

When the growth would exceed the PEOF, the logic attempts to extend the physical file size and retry growing the record in place (within the newly extended PEOF). At runtime, COMPATIBILITY NO_VAR_PEOF, disables this support, and leaves the growth in place activated as long as the record fits within the current PEOF.