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 onspaces -ch: 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 Informix® Guide to SQL: Syntax.

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