Use the following parameters to specify how the database server should manage particular types of disk space.
Configuration Parameter | Description |
---|---|
DBSPACETEMP | Specifies a list of dbspaces that the database server can use for the storage of temporary tables. For more information, see Creating a Temporary Dbspace. |
FILLFACTOR | Specifies how much to fill index pages when indexes are created. For more information, see your IBM Informix Dynamic Server Performance Guide. |
ONDBSPACEDOWN | Defines how the database server treats a disabled dbspace that is not a critical dbspace. |
SBSPACENAME | Specifies the name of the default sbspace. For more information, see Control of Where Data Is Stored.. |
SBSPACETEMP | Specifies the name of the default temporary sbspace. For more information, see Temporary Sbspaces.. |
SYSSBSPACENAME | Specifies the name of the sbspace in which the database server stores statistics that the UPDATE STATISTICS statement collects for certain user-defined data types. |