MODIFY...TO PHYS_CONSISTENT | PHYS_INCONSISTENT
Syntax to mark a table as physically consistent/inconsistent:
MODIFY tablename|indexname TO PHYS_CONSISTENT|PHYS_INCONSISTENT
A physically inconsistent table has some form of physical corruption. A table is marked physically inconsistent if rollforwarddb of that table fails for some reason, or if the table is a secondary index and point-in-time recovery has occurred only on the base table.
The MODIFY...TO PHYS_CONSISTENT command marks the table as physically consistent but does not change the underlying problem.
Last modified date: 04/26/2024