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 IBM® 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 IBM Informix DataBlade API Programmer's Guide and the HCL Informix Enterprise Replication Guide.


Copyright© 2018 HCL Technologies Limited