Batch Processing & Reporting › The Archive/Restore Program (CAKSARCH) › The BACKUP Option › Rules

Rules

• Never use a where_clause to backup data tables. If you use a where_clause, not all the data in that table will be backed up.
• Never archive tables by their synonym name. Always specify the fully qualified table name or you will not are not able to properly restore the tables.