One archive statement can only back up one table/object type at a time, which could be data, a dictionary, no fallback, or a journal. Users must submit multiple archive statements in order to archive each. Following is a description of each archive type:
Object type | Description |
Tables | Fallback-non fallback, partition-non partition, all AMP-multiple AMP |
Dictionary table | Back up DD |
No fallback table | Back up tables on AMP that is down during data table archiving |
Journal table | DD tables and journal tables |
An object is backed up based on the option you have specified in your ARCHIVE statement. You can specify all the objects in the database to be archived or select specific tables/objects from database to be archived. ...