Previous | Next | Contents | Index | Navigation | Glossary | Library |
Once you have completed all of the preparation steps, you can run the following programs from the Submit Requests window: Archive-Preview, Purge, Archive and Purge, and Archive to File. Each of these programs can be run as a separate process, however the Purge and Archive to File programs cannot be run until the Archive tables are populated by either the Archive-Preview or the Archive and Purge programs. Additionally, you can run the Archive-Restart program and Archive Reports from the Submit Requests window.
Archive-Preview | The Archive-Preview program selects and validates transactions that meet the purge parameters and copies the transaction information into the archive tables. A report is automatically generated after the archive tables are populated. The level of detail of this report is determined by the parameter you select when you start the Archive-Preview program. |
Purge | The purge process purges eligible transaction data. To run this program you must first run the Archive-Preview program as this identifies eligible transactions and stores the Ids in AR_ARCHIVE_PURGE_INTERIM. |
Warning: You should only run the Purge program if no users have been on the system since you started the Archive-Preview, as this process does not revalidate the id's stored in AR_ARCHIVE_PURGE_INTERIM.
Archive and Purge | The Archive and Purge populates the archive tables and purges transaction information in one step. This can also be run after Archive-Preview if you cannot be sure that no users have been on the system since you started the Archive-Preview. |
Archive to File | This is an optional program which can be used to copy the archive tables to a flat file if this is the desired method of storage. |
Archive-Restart | This program is used for error handling when the Archive-Preview or Archive and Purge fails. It can be used to save the system from having to revalidate all purge candidates, if Archive/Purge has completed the selection and validation phase, then fails during the archive phase. Archive-Restart clears the Archive Header and Detail tables and submits the archive report. When submitting the Archive-Restart program you must provide the following parameters: Archive Level, Summary Report Only, Number of Workers, Commit Size, and Archive Id. |
Archive Summary Report | Submit this report manually from the Run Reports screen if the report fails when submitted by the Archive and Purge or the Archive-Preview program. You can also submit this report to review summary information for previous Archive/Purge runs. The Archive Summary Report includes the amount and count of transactions selected for purge based on the AR_ARCHIVE_CONTROL table. When submitting the Archive Summary Report program, you must provide the Archive Id. |
Archive Detail Report | Submit this report manually from the Run Reports screen if the report fails when submitted by the Archive and Purge or the Archive-Preview program. The Archive Detail Report includes a breakdown of the above summary information by customer. This report is based on the AR_ARCHIVE_HEADER table. When submitting the Archive Detail Report program, you must provide the Archive Id. |
Attention: If you wish to ensure consistency between the Archive-Preview and the Purge, no users should be on the system in the interim.
Warning: Ensure that you move your archive output from the AR_TOP/out directory to an appropriate storage area. Otherwise, it will be deleted when your system administrator clears the output directories.
Warning: You cannot rollback a TRUNCATE statement.
Previous | Next | Contents | Index | Navigation | Glossary | Library |