Archiving Data Directly to a Target Environment or Purging

The AR-DCDT background process loops through the archive root instructions related to approved archive root objects (they were set to approved in Step 3: Recursive Integrity Check). The processing order is by Primary archive root object reference, from the lowest level Child archive root objects up to the Primary archive root object. The program issues a commit after each Primary archive root instruction has been processed. If a validation error occurs while processing an archive root instruction, the program deletes all of the archive root objects whose root instructions reference the same Primary archive root object.

This background process processes archive root objects related to the specified Archive or Purge DB process. You specify the DB process as a parameter on the batch control.

Execute Processing Algorithms

If there are processing algorithms associated with the archive root instruction being processed, both programs execute them before the data is deleted. These algorithms resolve foreign key references on production data that reference the subset of data to be archived. They may also resolve aggregate summaries (e.g. updating a summary adjustment to maintain a service agreement balance).

Delete Production Data and Root Object

Both programs handle the deletion of production data. Purge DB processes are handled differently than Archive DB processes.

For a purge:

• The program calls the driver specified on the archive root object's maintenance object to validate intra-database foreign key references.
• If the archive root object's underlying data is not referenced by other data in the environment, the program deletes the underlying production data.
• The program deletes the archive root object and archive root instruction.

For an archive:

• The archive root object's underlying production data is copied to the archive environment's database using the archive environment's synonym prefix and the archive root object's underlying production data is deleted.
• For each table in the archive root object's maintenance object hierarchy that has a key table, the program updates the key value record related to the archived record with the universal environment identifier of the supporting archive environment. Refer to Inter-Database Foreign Key References.
• The program deletes the archive root object and archive root instruction.