DefInitialFileSize

Integer (prefix multiplier)

128K

Purpose

The DefInitialFileSize parameter specifies the size to which database files are preallocated when they are first created. You can set the initial file size to values in the range 64K through 16,384P bytes.

For details about the JADE Database utility Set File Attributes operation that enables you to override this value for selected files, see "Using the Set File Attributes Command" or "fileAttributes", in Chapter 1 of the JADE Database Administration Guide.

Parameter is read when …

The database server node is initialized; for example, when you restart the database server.

Hint

This parameter enables you to preallocate database files at close to the expected file size.

Pre-allocation provides the opportunity to mitigate the usual overheads, including file system fragmentation (since files can be defragmented prior to use).