Archiving Commitment Control Records and Tables

This section provides an overview of the archive process flow and lists the pages used to archive data.

To archive commitment control records and tables, use the Archive Data to History (PSARCHRUNCNTL), Define Query Bind Variables (PSARCHRUNQRYBND), and the Audit Archiving (PSARCHIVEAUDIT) components.

Page Name

Definition Name

Usage

Archive Data To History Page

PSARCHRUNCNTL

Select an archive template and query and select the action you want to take in the archiving process.

Define Query Bind Variables page

PSARCHRUNQRYBND

Click the Reset Query Bind Variables button and enter the values that are used to select the data to be archived.

Archive Data To History Page

Audit Archiving page

PSARCHIVEAUDIT

View the number of rows selected to be archived for each table for a specific archive run.

You use the Data Archive Manager to perform an archive.

Use the same run control page for each step in the process except for auditing the archive selection.

Perform these tasks to archive commitment control records and tables.

  1. Archive to the history tables by selecting the archive template and query on the Archive Data to History page for the type of commitment control archive procedure that you want to accomplish.

    By clicking Reset Query Find Variables on the Define Query Bind Variables page you can reset criteria.

    Note: You can run the archive process multiple times to create various what-if scenarios based on the archive date.

  2. (Optional) Review the number of rows that were selected for archiving for each table on the Audit Archiving page.

    This page lists the number of rows that were selected for archiving for each archive ID (template), archive batch number, and table combination.

    Note: This page displays data only if you select the Audit Row Count check box on the Archive Data to History page.

  3. Delete the archived records and tables from the active database tables for a specific archive ID (template) and batch number on the Archive Data to History page.

  4. (Optional) You can rollback archived data from the history tables for a specific archive ID (template) and batch number using the Archive Data to History page if, for example, you delete data from records and tables from the active database in error.

  5. Off load data in the history tables to another database or to flat files.

  6. Remove data from the history tables for a specific archive ID (template) and batch number using the Archive Data to History page.

The data in the history tables is keyed by the archive ID (template) and batch number for each archive run. If you want to see data in the tables selected to be archive, you can run a query on the history tables

Important! If you decide to run the archive selection process again, for example, because you did not select the correct data, you must first use the Data Archive Manager option to remove the previous data from the history tables.