Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

COALESCE_TRNLOG

COALESCE_TRNLOG

Attempt to combine the deleted space with adjacent deleted space that already exists in ctTRNLOG files that do not have a RECBYT index (default is OFF). Combining deleted space can reduce fragmentation.

To enable this behavior, either:

  • Add the server keyword COALESCE_TRNLOG ON

or

  • Set the global variable ctcoaltran = YES in a standalone compile.

TOCIndex