RESTARTABLE_RESTORE (IDS)

Use the RESTARTABLE_RESTORE configuration parameter to enable or disable restartable restores.

onconfig.std value

ON

if value not present

ON

range of values

OFF

Disables restartable restore. If a restore fails and RESTARTABLE_RESTORE is OFF, you will not be able to restart it.

ON

Enables restartable restore. Set RESTARTABLE_RESTORE to ON before you begin a restore. Otherwise, you will be unable to restart the restore after a failure.

takes effect

If you need to restart a physical restore, you do not need to restart the database server before you can use RESTARTABLE_RESTORE. If you need to restart a logical restore, you must restart the database server before you can use restartable restore.

Turning on RESTARTABLE_RESTORE slows down logical restore performance. For more information, see Using Restartable Restore to Recover Data (IDS). For information on the physical log, see the IBM Informix: Administrator's Guide.