Best Practices - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Recommended Archive Tasks

Requirements for how often and when to archive data tables vary from site to site. For tables that change on a regular basis, the best practice is to archive data once a week. The following section provides suggestions for archiving on a daily and weekly basis.

Daily Archive Tasks

If you have permanent journals, perform the following procedure on a daily basis:

1 Submit a CHECKPOINT WITH SAVE statement for each journal table. This appends any changes stored in the active journal subtable to the saved journal table, and initiates a new active journal subtable.

2 Archive each saved journal.

3 Delete the saved journal subtable from the saved journal.

Weekly Archive Tasks

Teradata recommends that you submit an all-AMPs ARCHIVE of all data tables (or selected partitions of a PPI table) that change often, at least on a weekly basis. However, you may need to adjust how often you perform routine archiving based on the amount of data and based on how often your data changes.