Previous Topic: FIX StatementNext Topic: PAGES Option


FIX Parameter

       / SIMULATE \
,FIX = < UPDATE   >

The FIX parameter initiates either simulated or actual corrections of the database.

SIMULATE displays the intended corrections of detected integrity errors without actually applying the corrections to the database. You can inspect the corrections before updating the database in a subsequent audit run.

UPDATE applies corrections to integrity errors detected in the audit phase by updating the database. If you specify UPDATE in the FIX statement, you must also specify READYMODE=UPDATE in the PROCESS statement.

It is best to specify FIX=SIMULATE before using FIX=UPDATE. If the proposed corrections appear acceptable, you can then correct the detected errors by making a follow-up run using the extract files created during the audit phase.

Note: Be sure not to apply any updates to the database between runningthe audit and fix phases. Such updates could change the results of the fix processing or cause the fix phase to terminate abnormally.