Express Mode

The express mode has the following features:

• Locks tables for exclusive use by the load utility
• Disables referential and constraint checking on the table
• Requires a level-0 backup
• Sets all objects (such as indexes or constraints) to disabled before loading
• Reenables all objects after loading, if possible, and flags objects that cannot be reenabled in the violations and diagnostic tables
• Supports loading of raw tables

Express mode has the following limitations:

• Does not support:
  • Logging mode or ANSI mode
  • Tables that contain smart large objects (binary large objects or BLOBs, character large objects or CLOBs)
  • Tables that contain simple large objects (TEXT and BYTE) or extended data types
  • Loading of data on a heterogeneous data replication (HDR) replicated table from a database that has transactions
  • A table that has a fragmentation strategy and has a WITH ROW IDS clause to enable using row IDs with fragmentation
  • Tables with primary key constraints when child table records refer to the load table
  • Rows that are larger than the system page size

    For information about page size, see the IBM Informix: Administrator's Guide.

  • The static-hash access method
• Does not invoke triggers on the loaded data