Create Table Wizard - Table Options

Use this page to specify the lock mode, the auto update statistics, and other table options a new table.

Lock Mode

Set the locking granularity of the table to Page or Row (default).

Auto Update Statistics Options

Prerequisite: For the auto update statistics options, the OpenAdmin Tool (OAT) for Informix® requires IBM® Informix 11.70.

The database server updates statistics automatically according to a predefined schedule and a set of expiration policies. The Auto Update Statistics (AUS) maintenance system runs the appropriate UPDATE STATISTICS statements to optimize query performance. You can use the update statistics options to specify the minimum percentage of change required for the statistics for this table to be considered stale. Only the statistics that are considered stale are updated. For example, when the minimum change threshold is 10% and 10% of the table changes, the statistics that are considered stale are updated.

Use the system setting

Select this option to use the threshold that is set for the database server with the STATCHANGE parameter in the onconfig file. The default value is 10%.

Set the threshold

Select this option to set a specific threshold for this table only. The system setting in the onconfig file is not changed.

Table Options

Row version columns (VERCOLS)

Select this option to create the two shadow columns that support update operations on secondary servers in high availability clusters.

Conflict resolution columns for ER (CRCOLS)

Select this option to create the two shadow columns that are used for conflict resolution in Enterprise Replication (ER).

Consistency checking columns for ER (REPLCHECK)

Select this option to create the shadow column ifx_replcheck that is used to increase the speed of consistency checking in ER.

Primary key columns for ER (ERKEY)

Prerequisite: This option requires Informix 11.70.

Select this option to create the three shadow columns that Enterprise Replication uses for a primary key: ifx_erkey_1, ifx_erkey_2, and ifx_erkey_3. These shadow columns are indexed and can be viewed in the system catalog tables. A unique index and a unique constraint are created on the table using these columns. Enterprise Replication uses that index instead of requiring a primary key.

Selective row-level auditing (AUDIT)

Prerequisite: This option requires Informix 11.70.

Select this option to record row-level events for the table when selective row-level auditing is enabled for the database server. When selective row-level auditing is enabled for the database server, row-level events of only the selected tables are recorded in the audit trail. Selective row-level auditing can compact audit records so that they are more manageable and potentially improve database server performance. When selective row-level auditing is not enabled for the database server, this option has no effect on auditing.

The option is disabled when selective row-level auditing is disabled on the database server. To enable selective row-level auditing on the database server, in the audit configuration file, ADTCFG, set the ADTROWS parameter to 1 or 2. You must be a database system security officer (DBSSO) to set this parameter.

Automatic Compression (COMPRESSED)

Select this option to automatically create a compression dictionary and to automatically compress the data when 2000 or more rows of data are loaded into the table.