Release 10.1A: OpenEdge Data Management:
Database Administration

> ## No Crash Protection (-i)

> Operating system and syntax | UNIX Windows | `-i`
> Use with | Maximum value | Minimum value | Default
> CC, DBS | – | - | -

> Use No Crash Protection (-`i`) to run the database without integrity or database recovery. When running without database integrity, the database engine writes fewer data and before-image blocks to the disk. In this mode, some procedures (such as those that create and delete large numbers of records) can run significantly faster than if they are running with database integrity.

> When running 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 your database with the -`i` parameter and the database 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 that started without crash protection, restore the backup copy and rerun the necessary procedures. For information on restoring a database, see Chapter 6, " Recovering a Database."

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095