Storage parameter file

The storage parameter file provides a way to affect the distribution and configuration of table and index objects at create time. Storage parameters are used by the database driver whenever a DDL statement such as a create table or create index statement is executed. The following is an example of an entry in the storage parameter file:

*:*:T:FILEGROUP filegroupname

In this example, the database driver adds the “on <filegroup name>” clause to the create statement during table creation.

A storage parameter file is defined for each database driver. The storage parameter file is located in this directory: %BSE%\lib\msql For more information about the name of the file and the format of the storage parameter file, see "Parameter file formats and configuration options".