Maintaining Data Records

A lot of data accumulates during daily operation of an AE system.

This includes:

Statistical records
Reports
Messages and data for the Revision Report and the Open Interface to Output Management Systems

One method to maintain the AE database is using the following utilities:

AE.DB Archive
AE.DB Reorg
AE.DB Unload

General

The utilities included in the maintenance procedure can be called in batch mode (see Start Parameters). Use this opportunity and create a workflow in your AE system, which carries out the individual steps on a regular basis (see example)! The particular settings need to be specified only once in the utility.

Note that system client 0000 should also be maintained! It can accumulate major amounts of data as it contains the log files of the servers and agents and other data.

Note that you must not backup the table DIVDB when you use a DB2 database and want to backup it manually before you run the reorganization process. The reason is that the reorganization process uses the table DIVDB running the statement

ALTER TABLE DIVDB ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE

and you can neither restore the backup data nor run the command ROLLFORWARD anymore.

Procedure

	1.	Archiving

The utility AE DB ArchiveDas Dienstprogramm AE DB Archive dient dazu, den stetig wachsenden Bestand an Daten aus der Automation Engine-Datenbank auszulagern. serves to archive messages, statistics and reports. The generated files are clearly structured in folders organized by clients and archiving runs. As folder names also contain the corresponding dates, it is easier to locate particular data records.

Archived data can be viewed with the Archive Browser at any time. Set filters to limit the number of data records to be displayed depending on your requirements.

	2.	Reorganizing

Use the utility AE DB ReorgDienstprogramm für die Reorganisierung der Automation Engine-Datenbank. Datensätze werden auf Grund bestimmter Einstellungen mit einem Löschkennzeichen versehen. for the subsequent reorganization of data records. These are marked with deletion markers in this step but are not yet deleted from the database!

	3.	Unloading the data records

Call the utility AE DB UnloadDienstprogramm zum Entladen der Automation Engine-Datenbank to finally erase the data records from the database. Use the option "Reorganize database". If necessary, this utility can also be used for resetting archive and reorganization flags.

Performance Improvement

The archiving, reorganizing and unloading processes can take some time if huge amounts of data are involved. The following tips can help to improve performance by accelerating the above processes:

When reorganizing, avoid using the option "Keep the last n statistics." By doing so, the utility AE DB Reorg does not count all statistical records of all objects but directly starts the reorganization process using the date as a basis.
Only reorganize reports if they should be reorganized before the statistical records. If this option is not activated, the utility AE DB Reorg reorganizes reports together with the statistical records.
In the utility AE DB Unload, specify that no REORG files should be generated. The corresponding parameter suppress_output= is available in the INI file section [REORG].