8. SQL Statements : MODIFY : Modify...to Log_consistent|Log_inconsistent
 
Share this page                  
Modify...to Log_consistent|Log_inconsistent
A logically inconsistent table is out-of-step in some way with one or more logically related tables. A table is marked logically inconsistent if the table is journaled and the user enters rollforwarddb +c -j on the table, or if the table is journaled and the user rolls forward to a point-in-time. For example, if two tables are logically related through referential constraints, and only one is moved to a specific point-in-time, the table is marked logically inconsistent.
The MODIFY TO LOG_CONSISTENT command marks the table as logically consistent but does not fix the underlying problem.