Define the data to archive

The access definition references the tables that contain the data, provides selection criteria for the data, prescribes the way that relationships between tables are traversed, and provides other specifications such as index parameters and actions (SQL statements, including calls to stored procedures) to be executed during processing. In other words, an access definition defines the data you want to archive and provides table specific parameters for processing.

For this scenario, you create an access definition that is local, or exclusive to the current archive request. You:

• Select the tables that contain the data you want to archive, and specify delete and archive index preferences for them.
• Define selection criteria for the data—in this example, a set of ORDERS more than two years old.
• Define the traversal path—the relationships between tables that are traversed in processing and the direction in which they are traversed.
• Review the traversal path to ensure the appropriate data is selected.