Documentation

Database Administrator's Guide

Previous Topic

Next Topic

TRAN_DATA_FLUSH_SEC

TRAN_DATA_FLUSH_SEC <time_limit_in_seconds>

Sets the time limit in seconds that a data cache page can remain dirty before it is written to the file system cache.

  • Specify IMMEDIATE to cause dirty pages to be written immediately.
  • Specify OFF or -1 to disable the time limit-based flushing.

This option can be changed using the ctSETCFG() API function or the ctadmn utility.

Note: Enabling this option disables checkpoint flush operations.

Default: -1 (disabled)

See Also

CHECKPOINT_FLUSH

TRAN_INDEX_FLUSH_SEC

NONTRAN_DATA_FLUSH_SEC

NONTRAN_INDEX_FLUSH_SEC

TOCIndex