Logging Options

Use the Logging Type options to specify logging characteristics that can improve performance in various bulk operations on the table.

Other than the default option (STANDARD) that is used for OLTP databases, these logging options are used primarily to improve performance in data warehousing databases.

A permanent table can have either of the following logging characteristics.

Logging Type
Effect
STANDARD
Logging tables that allow rollback, recovery, and restoration from archives. This type is the default. Use this type of table for all the recovery and constraints functionality that OLTP databases require.
RAW
Nonlogging tables that do not support primary key constraints or unique constraints. but that support referential constraints, and can be indexed and updated. Use this type of table for quickly loading data.
Warning: Use raw tables for fast loading of data, but set the logging type to STANDARD and perform a level-0 backup before you use the table in a transaction or modify the data within the table. If you must use a raw table within a transaction, either set the isolation level to Repeatable Read or lock the table in exclusive mode to prevent concurrency problems.

The CREATE RAW TABLE statement is not supported on secondary servers within a high-availability cluster.

For more information on these logging types of tables, refer to your HCL Informix® Administrator's Guide.


Copyright© 2019 HCL Technologies Limited