DefFileGrowthIncrement

Integer (prefix multiplier)

128K

Purpose

The DefFileGrowthIncrement parameter specifies the size in bytes by which the database files are incremented as they grow (that is, the logical extent size).

You can set the growth increment to values in the range 64K through 4G 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

As database files grow in small variable increments on demand and the gradual growth incurs both a direct I/O performance penalty and an indirect performance penalty due to disk fragmentation, use this parameter to tailor the amount by which your database files grow.