Select the archive options.
Data Export Format
Store the data in the native database format.
Store the data in XML format.
Store the data in the Parquet format.
Check this box to select the database the data will be archived to.
The archive database host. Data is moved here prior to being moved to media.
- Database Name
The archive database name.
- Connect Details
The password used to access the Archive Database.
Create uniform view for Archive and History tables
A view is created under the source database that is a union of the source table and archived data.
When the uniform view option is selected the archive job creates views in the source and destination databases as per the archive criteria and UNION ALL of all jobs.
The database views are created by performing a UNION of all jobs by the archive job.
The view is created by default on the destination (archive) database.
The view is created under the same schema used to archive the data, configured at instance properties.
For example if Jobid 100 picks up 2 records with status=’A’ and Jobid 101 picks up 5 records with status=’B’ then both databases have 7 records, using the following:
CREATE OR REPLACE VIEW archiveuser.<table> AS SELECT * FROM source_schema.<table> UNION ALL SELECT * FROM histdb.<table>@<dblink>
Path for the Archive Data Files
The directory path for the archived data file. The datafiles are created in this path.
When you choose to store the data in the XML format, afterr the archive job completes, there are two files per table placed in this directory. There is an xml file type that is in the <Path for Archive Data Files>/Data directory that has the following format:
There is an xsd file type that is in the <Path for Archive Data Files>/Config directory that has the following format:
Data Retention Settings
- Archive Tables
The number of days the data is saved in the history tables on the archive database. The default is 365 days.
The number of days the data is saved on the media The default is 1825 days (5 years).