Recoverability of Table Types

The database server checks the recoverability level of the table during a load:

• If the table type is RAW, the database server can use light-append (or express) mode to load data and process check constraints. If the database server crashes during the load, the data loaded is not rolled back, and the table might be left in an unknown state.
• If the table type is STATIC, the database server cannot load the data at all.
• If the table type is OPERATIONAL, the database server can roll back to the preload state if the database server fails. If you want to have complete recoverability of the table without reloading the data, you must run a level-0 backup after the load.
• Only deluxe mode supports data recoverability. Deluxe mode uses logged, regular inserts. To recover data after a failed express-mode load, revert to the most recent level-0 backup. The table type must be STANDARD for this level of recoverability.

For information on restoring table types, see the IBM Informix: Backup and Restore Guide.