Changing the -Df Settings

Home | Previous Page | Next Page Administrative Utilities > Managing Storage Spaces with the onspaces Utility > Create an Sbspace or Temporary Sbspace >

Changing the -Df Settings

As the database server administrator, you can override or change the -Df default settings in one of the following ways:

To change the default settings for an sbspace, use the onspaces -ch option. For more information, refer to Change Sbspace Default Specifications.
To override the following -Df default settings for a specific table, use the SQL statements CREATE TABLE or ALTER TABLE:
- LOGGING
- ACCESSTIME
- EXTENT_SIZE
- NEXT_SIZE
For more information on the ALTER TABLE and CREATE TABLE statements, see the IBM Informix Guide to SQL: Syntax.

The programmer can override these -Df default settings with DataBlade API and ESQL/C functions. For information about altering storage characteristics of smart large objects, see the IBM Informix DataBlade API Programmer's Guide and the IBM Informix ESQL/C Programmer's Manual.