Progress
Database Administration
Guide and Reference


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) may 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 a Progress session that started without crash protection, restore the backup copy and rerun the necessary procedures. For information on restoring a database, see Recovering a Database."


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