Product Information > JADE Database Administration Guide > Chapter 1 - Using the JADE Database Utility > fileAttributes

fileAttributes

The fileAttributes command specifies the initial file size and the extent size for file growth for all database files or for selected database files, so disk allocation for database files is as expected.

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

Specify the extentSize parameter, the initSize parameter, or both the extentSize parameter and the initSize parameter. Set these values explicitly (for example, 16384) or by using a prefix multiplier (for example, 16K).

The minimum value is 4K, the default initial file size is 16K, and the default extent of growth is 64K.

The syntax of the fileAttributes command in the jdbutilb command line is as follows.

jdbutilb path=database-path
         ini=initialization-file-name
         [fileAttributes [file-list] initSize=bytes|suffix-multiplier 
         extentSize=bytes|suffix-multiplier|
         initSize=bytes|suffix-multiplier|
         extentSize=bytes|suffix-multiplier]