LOADONTOHEAP

The LOADONTOHEAP option specifies whether the File Handler loads the file into memory before executing any I/O operations.

Syntax:

LOADONTOHEAP = { ON } { OFF }

Parameters:

ON: The File Handler loads the entire file into memory when it opens the file, executes I/O operations on the file in memory, and writes the file back to disk when it is closed.
OFF: The File Handler leaves the file on disk and executes I/O operations on the file on disk.

Properties:

Default:

0FF

Comments:

You can set LOADONTOHEAP to ON only for non-shared files.
You should use the ON setting with care and only on small files.