No Crash Protection (-i)

Use No Crash Protection (-i) to tell OpenEdge to run without using database integrity or database recovery.

Operating system and syntax UNIX / Windows -i
Use with Maximum value Minimum value Single-user default Multi-user default
Client Connection, Database Server — — — —

When running OpenEdge without database integrity, the database engine writes fewer data and before-image blocks to the disk. In this mode, some ABL procedures (such as those that create and delete large numbers of records) run significantly faster than if they are running with database integrity.

When running OpenEdge with the -i parameter, transaction undo is supported. Therefore, there will still be a before-image file, which might grow quite large during very long transactions.

Use this parameter to do bulk data loading or for large batch runs. It reduces the number of disk input or output operations. Loading a database for the first time is a good example of a use for this parameter.

CAUTION: If you run OpenEdge with the -i parameter and OpenEdge fails for any reason, you cannot recover the database.

Do not use the -i parameter unless you have a complete backup of the database and can rerun procedures in case of a system failure. If the system fails during an OpenEdge session started without crash protection, restore the backup copy and rerun the necessary procedures. For information about restoring a database, see Manage the OpenEdge Database.

The following messages might appear when starting an OpenEdge session after a system failure:

  • After a system failure while a full-integrity OpenEdge session was running:
    **The last session was abnormally terminated.
**Any incomplete transactions are being backed out.
**Database recovery is complete. You must rerun all active transactions.
  • After a system failure while a no-integrity OpenEdge session was running:
    **The last session was abnormally terminated.
**The last session was run with the -i no integrity option.
**Your database cannot be repaired, you must restore a backup copy.