Archiving or Restoring a Down Table
During an archive operation, the system checks the table header to verify if it contains any down status or down region information. If there is a down subtable or down region, it reports an error to ARCMAIN.
When archiving a table that is marked down or contains down regions, ARCMAIN either aborts the archive operation if it is a table-level archive, or skips the table and proceeds with the next object if it is a database-level archive operation. (In other words, in a multitable archive operation such as a database, cluster, or AMP archive, when the system encounters an error of down subtable or down region, ARCMAIN skips the table and proceeds with the next object.)
If you encounter an error message from ARCMAIN about a down region, do one of the following:
Then use the ALTER TABLE tablename RESET DOWN statement, and the system will delete the down regions of that table from the table header on each AMP.