Database Administrator's Guide

NONTRAN_DATA_FLUSH_SEC

NONTRAN_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 to disable time limit-based flushing.

Default: IMMEDIATE

See Also

• Controls for Performance AND Safety of Non-Transaction Updates