SQL Reference Guide > SQL Reference Guide > SQL Statements > MODIFY > MODIFY...TO LOG_CONSISTENT | LOG_INCONSISTENT
Was this helpful?
MODIFY...TO LOG_CONSISTENT | LOG_INCONSISTENT
Syntax to mark a table as logically consistent/inconsistent:
MODIFY tablename|indexname 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.
Last modified date: 08/29/2024